Saving changes is not permitted in SQL 2008 Management Studio
I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
I used to write ALTER statement (e.g. ALTER Table.. .ALTER Column...) so I don't really know what is the error message mean. Today, I search it during my Xmas holiday and know that there's a option in Tools | Options | Designer | Prevent saving change that require table re-creation.
Uncheck it and then I can modify table structure in GUI now. :)
Regards,
Colt