March 12, 2007 at 1:16 pm
March 12, 2007 at 1:45 pm
I have never heard of this happening.
Have you considered the possibility of human error?
March 12, 2007 at 2:56 pm
March 12, 2007 at 4:19 pm
When you create a unique constraint, a unique index is created to enforce it.
-Eddie
Eddie Wuerch
MCM: SQL
March 13, 2007 at 7:48 am
You can observe that the query compiler will use a constraint as it would an index. As pointed out above, a UQ is enforced by creating an index. If you script out the table, and the constraint is somehow changed to a create index, why then we have a problem.
Think of it as a free lunch!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply