Wednesday, May 6, 2009

DEVELOPMENT: SQL Server 2008 - saving changes is not permitted

After installing SQL Server 2008 we were unable to save updates to any of the existing database tables. Every time we tried to save a change to the table, we got the following error:

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.

To resolve this, click the SQL Server Management Studio Tools Options Designers option and untick the "Prevent saving changes that require table re-creation" checkbox.


We hope this helps anyone else that's new to SQL Server 2008 development!

No comments: