getting an error about a constraint that doesn't exist?
Got this error on a table update:
 There is already an object named 'DF_jc-time-sh_emp-id_20080818125445337' in the database.
Could not create constraint. See previous errors.
I'm not quite clear on why I'm getting the error because a check of
INFORMATION_SCHEMA.TABLE_CONSTRAINTS on the target database reveals that this doesn't appear to exist on the target database.
I'm not using SQL Source Control, so the advice of creating a migration script isn't helpful to me.
Any guidance would be appreciated.