Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jusvistin
Yak Posting Veteran
81 Posts |
 Posted - 2003-08-16 : 07:21:06
|
Never seen this before.I'm working through Rob Viera's book Chapter 7, trying to script a constraint in Query analyzer by right clicking on the constraint in the object browser, but SS2K is giving me the following error:
[SQL-DMO]The name 'CN_CustomerPhoneNum' was not found in the Checks collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.
This is the T-SQL I used to create the constraint:ALTER TABLE customers with nocheck add constraint CN_CustomerPhoneNum check (Phone like '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]')Can anybody tell me why I'm getting the error, or what I'm doing wrong ?Thanks,Kevin |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-17 : 21:44:31
|
| I just tried it, works for me, so it's not the code.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
Jusvistin
Yak Posting Veteran
81 Posts |
Posted - 2003-08-18 : 00:58:25
|
| Well,I'll be a monkey's uncle - now it works on my box too.::scratches head::Hmpf! Puters!Kevin |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-18 : 01:04:37
|
glad to hear it.Cheers  --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Error trying to Script a Constraint in QA