WITH NOCHECK

mohaaronmohaaron Posts: 46
edited April 10, 2007 12:32PM in SQL Data Compare Previous Versions
When syncronizing data I see that WITH NOCHECK is being used a lot when creating the constraints after they have been dropped. Is the add constraint code be created from the current schema or is there a way to specify not to use WITH NOCHECK?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    Data Compare recreates all keys with NOCHECK. This stops the server from checking the data's consistency, going with the assumption that the data should already be in the same state as it was in the source server (consistent or not!)
Sign In or Register to comment.