SQL Server 2008 Error: Saving changes is not permitted

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.

Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.

Enter your email id

Delivered by FeedBurner
Tweet this article Facebook Google+

Related Posts:

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