Can I use "Create Domain" in Sql Server 2008?
-
Hello I am trying to execute this query:
Create Domain Email
As
Varchar(255) Check (Position('@', Value) > 1)But the below error will occur:
Unknown object type 'Domain' used in a CREATE, DROP, or ALTER statement.
SignatureNotFoundException
..Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables. How did you expect this to work? Simply throw in the word "domain" and pray that Sql knows what you want? Computers don't work like that. You learn the computers language if you want things from it, not the other way around.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hello I am trying to execute this query:
Create Domain Email
As
Varchar(255) Check (Position('@', Value) > 1)But the below error will occur:
Unknown object type 'Domain' used in a CREATE, DROP, or ALTER statement.
SignatureNotFoundException
..now that I had my rant, let's try and find an answer to your problem. For that, we first need to get a clear description on the problem itself; as is know, I can only guess at what you are trying to do.
- Are you trying to store email-adresses? (creating them is done in another server)
- Create a login? (Google for "create login")
- Something else?
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
..Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables. How did you expect this to work? Simply throw in the word "domain" and pray that Sql knows what you want? Computers don't work like that. You learn the computers language if you want things from it, not the other way around.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
Eddy Vluggen wrote:
Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables.
A DOMAIN in SQL is defined as a set of values for a given attribute! So, of course SqlServer knows something about domains! It just called different! In SqlServer you use ADD CONSTRAINT to simulate domains.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Hello I am trying to execute this query:
Create Domain Email
As
Varchar(255) Check (Position('@', Value) > 1)But the below error will occur:
Unknown object type 'Domain' used in a CREATE, DROP, or ALTER statement.
SignatureNotFoundException
Well, as I know, DOMAIN is not implemented in SqlServer but as a SQL-Language element it's a reserved word. You can use ADD CONSTRAINT to check the values (google for sql server add constraint, there are lot of samples).
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Eddy Vluggen wrote:
Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables.
A DOMAIN in SQL is defined as a set of values for a given attribute! So, of course SqlServer knows something about domains! It just called different! In SqlServer you use ADD CONSTRAINT to simulate domains.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Hello I am trying to execute this query:
Create Domain Email
As
Varchar(255) Check (Position('@', Value) > 1)But the below error will occur:
Unknown object type 'Domain' used in a CREATE, DROP, or ALTER statement.
SignatureNotFoundException
Perhaps an alias data type ? http://msdn.microsoft.com/en-us/library/ms175007(v=sql.100).aspx
-
Perhaps an alias data type ? http://msdn.microsoft.com/en-us/library/ms175007(v=sql.100).aspx
-
..Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables. How did you expect this to work? Simply throw in the word "domain" and pray that Sql knows what you want? Computers don't work like that. You learn the computers language if you want things from it, not the other way around.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
..Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables. How did you expect this to work? Simply throw in the word "domain" and pray that Sql knows what you want? Computers don't work like that. You learn the computers language if you want things from it, not the other way around.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
..now that I had my rant, let's try and find an answer to your problem. For that, we first need to get a clear description on the problem itself; as is know, I can only guess at what you are trying to do.
- Are you trying to store email-adresses? (creating them is done in another server)
- Create a login? (Google for "create login")
- Something else?
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]