MSSQLWIKI

Karthick P.K on SQL Server

«
»

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created

Posted by Karthick P.K on July 31, 2010

Error

Saving changes is not permitted. The changes you have made require the following
tables to be dropped and re-created. You have either made changes to a table that
cant be re-created or enabled the option Prevent saving changes that require the
table to be re-created.

Resolution

SQL Server management studio—> Tools –>Options—> Designers –>Table and database designers –>Uncheck “Prevent saving changes that require table recreation”

image

Note: Some operations such as alter column will drop and recreate table. Ensure you do not abort SSMS while operation in progress. You might loose the table. I would recommend

script the changes and and run script in query window (or) At least review the script before you save changes using SSMS.

Thanks

Karthick P.K

This entry was posted on July 31, 2010 at 12:16 AM and is filed under SQL Server Tools, SSMS. Tagged: , , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created”

  1. Bigoo said

    June 3, 2012 at 11:20 AM

    Thank you! Nice solution.

    Reply

  2. Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

    January 11, 2014 at 1:00 PM

    […] Saving changes is not permitted. The changes you have made require the following tables to be droppe… […]

    Reply

Leave a comment

«
»