June 9, 2013 at 10:05 pm
Dear All
There is hardly any data in the table on which i have defined foreign key. But when i am setting NOCHECK constrian it taking long time / not getting over.
What may be the reason?
Regards
June 10, 2013 at 1:33 pm
What do you mean by setting NOCHECK? Please post the full statement 🙂
June 11, 2013 at 12:27 am
Can you please provide us some more details that what you did and what you want to achieve?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 11, 2013 at 1:49 am
issue is resolved. Rollback process was going on hence could not run the disable foregin key command
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply