Saving Changes is not permitted Error in SqlServer 2008 when changing table

Finally I started using SQL Server 2008 on my Windows 7 work station. I created a new database. Created a new table to test some code. Then i decided to change schema of my table. Made a simple change and marked one field to be Identity field. Moment I hit OK, i got the following error message.

Saving changes is 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.

This is fresh install of SQL Server 2008 and I did not recall of enabling such option. These minor changes in SQL2005 never used to trigger such warnings. After clicking on few options menu options i figured out where this option is enabled. Goto to Tools > Options menu. It will bring up wizard for database options. Click on Designers link in left pane. It will bring up following options in right pane. Notice that Prevent saving changes that require table re-creation option is checked. You can uncheck this option to enable these table schema changes.

comments powered by Disqus

Search

Social

Weather

18.1 °C / 64.6 °F

weather conditions Clouds

Monthly Posts

Blog Tags