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? ThanksDoh! of course its DBCC CHECKCONSTRAINTS<br />couldnt see the wood for the trees <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />
]]>