Saving Table Changes in the Design Option
Problem: You have just modified a table in the Design Option in SQL Server 2008 Management Studio but it will not allow you to save the changes you made. You are getting an error that says:
“saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created…”
You can find the *solution* in this post by Tim Edwards (Twitter | Blog). I have encountered this issue few times and I thought it was an issue in SSIS or something (I was modifying lots of target tables). If I read Tim’s post on this prior to when I was having this issue, I should have saved a handful of time.