Using the 2/6/2007 CTP, the SQL Server DDL generated a script that passed the Parse check, but failed in execution due to duplicate CONSTRAINT names. The errors seem to be where there is a fixed length character type.
There were 5 instances of CONSTRAINT State_Chk, in the test. Manually changing the names to make them unique cleared the problem in this test. Let me know if uploading the .SQL file would help. BRN..
Log in to post a comment.