July 2009 Entries
A common error message many get when working with SQL server Management Studio 2008 is the “Saving changes is not permitted” error. This can occur when you try to change something using the designer tools, e.g. any graphical tools in SSMS.
The error in it’s full length reads like this:
“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.”
Followed by the table name that will be affected.
To get around this go to Tools –> Options. Well in there go to Designers and unmark the checkbox for “Prevent saving changes that require table re-creation”
