January 1, 2011 at 10:14 pm
please help me in previous topic . i have to drop all of clustered index and then recreate clustered index on new file groupe? Is that true ? ok . I did it i want to drop all of primary keys but i have many error with all of forign keys and my relations .what do I do?
January 2, 2011 at 8:39 am
What you should do?
Ask your (related) question in the original topic instead of starting a new one.
The people who helped you in the previous topic know already the context so they can help you better and other people, like me, don't have to go read other topics in order to help you. Or start a new topic but give at least enough background info.
On topic: you can try to disable all foreign key relationships, do the move and then re-enable them again.
Or you can drop and re-create them. You can generate the scrips in Management Studio.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply