Monday, 10 October 2011

SQL Server Foreign Key Constraint Issues

Added my responses to this article on SQL Server Central today, as we were having exactly the same issue occurring on SQL Server 2008 SP2...

http://www.sqlservercentral.com/articles/Foreign+Keys+(FK)/75346/

The fix we used, was to simply add the DROP_EXISTING = ON option to the creation of the new Index.

No comments:

Post a Comment

How to by pass the Jaguary X-Type enter security pin screen after changing battery

How to bypass security code on Jaguar X-Type touchscreen Satellite Navigational units. Just hold the skip track, AMEM and PTY buttons ...