Rules for "system named constraint and index names"

marclallen

Having the "Ignore system named constraint and index names" option enabled, it doesn't seem to be working all the time.

It failed to identify [DF__ABCD__EFGH__3C02494A] as a system named constraint.  I don't want to ignore all named constraints... I've had that bite me.

The SQL Server is 2008 R2, but that code might easily have been generated as early as SQL 2000.

Matthew_Chappelow

Compare looks for the flag in the system table to identify whether an object is system named or not.

It is therefore possible to have names in the results that look like system names if they are not actually system named.

marclallen

Ok, thanks.  I'll look more closely.  I'm still pretty new to SQL Compare and it might have flagged the indexes in addition to something else.