http://www.sqlservercentral.com/Content tagged Referential Integrity posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Some time ago, I loaded a large set of data into one my tables. To speed up the load, I disabled the FOREIGN KEY and CHECK constraints on the table and then re-enabled them after the load was complete. I am now finding that some of the loaded data was referentially invalid. What happened?http://www.sqlservercentral.com/redirect/articles/63695/2008/07/18http://www.sqlservercentral.com/redirect/articles/63695/Use this proc if you need to alter a column that is part of a primery keyhttp://www.sqlservercentral.com/scripts/Referential+Integrity/61707/2008/02/04http://www.sqlservercentral.com/scripts/Referential+Integrity/61707/