SQL Server 2008 notification Saving changes is not permitted

← PrevNext →

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.

Ok, 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 that says Saving changes is not permitted.

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.

← PreviousNext →