Unable to save the changes in SSMS

Asked By martha uy 0 points N/A Posted on - 02/18/2012

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

• Status: Open
• Question Views: 1211
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Perlas Draplin 5 points N/A #93082

Unable to save the changes in SSMS

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.

About Perlas Draplin

Questions
1

Answers
54

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 02/20/2012
• Question Category: MySQL Server