Friday, February 13, 2009

Saving changes is not permitted in Microsoft SQL Server Management Studio 2008

If you try to change columns in a table that you've created you will get the following message:

"Saving changes ins not permitted. The changes you have made require the following table 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 think this option isen't very useful as enabled by default.

The message explains itsel, you have to disable the "Prevent saving changesthat require the table to be re-created", but where is this option.
Tools -> Options -> Table and Database Designers -> Uncheck "Prevent saving changes that require the table to be re-created"

No comments:

Post a Comment