NOCHECK Constraint | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

NOCHECK Constraint

One of our databases has a lot of foreign key relationships. As part of a one off conversion process, I am disabling constraints on certain key tables while we reinsert the converted data. I then enable the constraints again. What I need is a way to recheck the constraint to make sure that the data inserted does not violate the constraints. The simple answer would be not to disable the constraints but this is not really an option due to various dependencies (bit of a catch-22 in terms of refilling the tables). Any way to do this? Thanks
Doh! of course its DBCC CHECKCONSTRAINTS<br />couldnt see the wood for the trees <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />