SqlServer : Saving changes is not permitted

With SqlServer, when you want to change the structure of a table, you may encounter the following warning message :

“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.”

warn1

To avoid this warning message, go to the “tools” menu, then click “Options”

toolsoptionsClick on the “Designer” node

Designers

Then uncheck the “Prevent saving changes that require table re-creation” checkbox

uncheck
And you are done, the message box will not appears anymore

Incoming search terms:

  • sqlserver saving changes is not permitted