Saving changes is not permitted in sql server


When we install new version of sql server then sometimes we are getting this error “Saving changes is not permitted in sql server” on adding new column or changing column in table.


If we check this in other PC then it is working fine. This is not a hosting problem.
we need to uncheck prevent saving changes option from Tools >> Options >> Designers >> Table and Database Designer. see below screenshot. so you can get better idea.


After unchecking the option, you can add or modify the tables.

Hope this will help you.

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>