When a table is modified and saved in SQL Server; an error is raised:

Saving changes is not permitted. The changes that 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.

You might have received the similar. I’m not the master of SQL or SQL Server and don’t use SQL queries while creating or modifying tables. I was working with SQL Server Management Studio and got jammed with issue. I was just wondering “what is going on?” and my friend Subhash suggested a simple tip to get rid of it.

This article describes you step by step method to solve the error you make one or more modification to table definition in SQL Server 2008.

How To:

1. Run SQL Server Management Studio (SSMS).
2. Click Tools menu, and then Options.
3. In the navigation pane of the Options window, click Designers.
4. Now Clear the Prevent saving changes that require the table re-creation check box, and then click OK.

If you are running Visual Studio, you can follow these steps:

1. Run Visual Studio 2008 or 2010.
2. Click Tools menu, and then Options.
3. In the navigation pane of the Options window, expand Database Tools and click Table and Database Designers.
4. Now Clear the Prevent saving changes that require the table re-creation check box, and then click OK.

Applies To:

• Visual Studio 2008
• Visual Studio 2010
• SQL Server Management Studio