How can we help you today? How can we help you today?

What's up with "The filegroup has changed. The table must be rebuilt." ?

After carefully partitioning and reloading the data into a large-ish table (almost a gig), I get this message when I try to commit the changes.

Questions:
1) What does it mean?
2) Why would I even consider letting an app "rebuild" a newly partitioned table that's working perfectly and exactly how I designed?
3) How do I make this go away?

It's frightening that this is even one button click away from happening. That should not be the case for any operational database.

thanks, Tom
tkreyche
0

Comments

1 comment

Sort by
  • Peter_Laws
    Hello Tom,
    Since you mentioned partitioning, are you utilising a clustered index, potentially moving the clustered index to a new filegroup?
    As for expected behaviour, we'd need a fair bit more information to determine that. I'd be happy to open a support ticket for you if you'd like to pursue that.
    Kind regards,
    Peter
    Redgate Product Support
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.