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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy