Friday, May 16, 2008

SQL Server: Temporarily disable constraints for data Load

for data loads that replace referenced data by new data (that validates against constraints of course), you can quickly disable constraints checking like this:


http://www.sqljunkies.com/WebLog/roman/archive/2005/01/30/7037.aspx