Monday, 13 December 2010

SQL - Saving Changes is not permitted when altering table

If you are trying to edit the data type in a table in SQL server and you get a message saying "Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created" then you will be pleased to know there is a setting for this that seems to be on as default in a new install.

If you open the settings screen from Tools > Options then go down to the 'Designers' node you should see an option called "Prevent saving changes that require table re-creation". If you remove the check mark from this option then you should be able to save as normal.

No comments:

Post a Comment