#22 SQL Server DDL Dup CONSTRAINT

[Brian Nalewajek]

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..