Home > SQL Programming > Saving Changes is not permitted,when Modified the table using SSMS

Saving Changes is not permitted,when Modified the table using SSMS

December 20, 2010

When i tried to modified the table structure using SSMS in SQL 2008 SSMS is not allowing me to modify the table i got the warring message that,Saving Changes is not permitted.

 

This is the good thing SSMS  has the facility to prevent the changes on the table design. because using query analyzer in all the version if you want to modify the table structure  it will drop and recreate the table, if you have very huge table and you want to modify the table structure using the GUI it will take huge time to recreate the table. this will create a production outage too.

How to resolve this . Go to > Tools >Options>table and database designer > uncheck the prevent and saving table recreation.

The following  screenshot will give the clear idea.

Note :  By Default this option will be enabled so user will not be able to modify the table .Please do not uncheck this option on production environment  use script to modify them.

Advertisements
Categories: SQL Programming
%d bloggers like this: