SQL Server – Saving changes is not permitted.

February 17th, 2013
It can be annoying when you have installed a brand new software on your PC, and it refuses to function the way you expect it to.

So you have installed SQL Server 2008 for the first time on your PC and created a new table using the design mode. Later you thought of editing or adding few columns and it refuses to obey your command and instead pops up a message.

Saving Changes

By default SQL Server 2008, prevents any changes on any table that you have created using the design mode on the Management Studio.

Note: Even in this situation, you can alter the table using the “Query Analyzer”.

This issue can be fixed by changing an option from the Management Studio itself.

Find the “Tools” menu on the Management Studio and select “options ...” submenu. In the “Options” window, select “Designers” (Tables and Database Designers in SQL Server 2012). Uncheck the “Prevent saving changes that require table re-creation” from the “Table Options”.

SQL Server Options

Now you can make the necessary changes.

advertise here
comments powered by Disqus

Join our Google Plus Community and be a part of a discussion!