How can we help you today? How can we help you today?

Rules for "system named constraint and index names"

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

Comments

2 comments

Sort by
  • 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.
    Matthew_Chappelow
    0
  • 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.
    marclallen
    0

Add comment

Please sign in to leave a comment.