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

About Sam Beauvois

Application Developer, .NET enthusiast since 2004, I'm interested in technology watch, usability, code quality, patterns & practices, UX, ...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>