Unable to save the changes in SSMS

Asked By 0 points N/A Posted on -
qa-featured

While trying to make a gathered index or a table that doesn’t consist of clustered index,

I encountered an alert coming from SQL Server Management Studio stating that “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 can’t be re-created or enables the option prevent saving changes that require the table to be re-created.” Clicking on the Cancel button will just open another alert from SSMS.

How can I handle this?

Save

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

Airport

Cancel SaveText File

SHARE
Answered By 0 points N/A #93082

Unable to save the changes in SSMS

qa-featured

Dear Martha,

Please perform the below mentioned steps to as a workaround to the issue.

1. Click on Tools > Options after the opening the application – SQL Server 2008 Management Studio (SSMS).Refer to the figure given below for a better understanding.

2. After opening the Options window, expand Designers by clicking on the plus sign next to it. Now Select Table and Database Designers.Uncheck the check box that next to Prevent saving changes that require the table re-creation.Click onOK to save the changes.

 

3. Please proceed with the changes that you trying earlier. A Validation Warning popup will appear.

Click on Yes to the same.

Login/Register to Answer

Related Questions