Saving changes is not permitted

Asked By simon clark 30 points N/A Posted on - 05/08/2012

When I try to alter any object in any database by using Microsoft SQL Management Studio, I get the following error message.

Could you help me in this regard, please?

 

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 can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

ErrorLog

• Status: Open
• Question Views: 1073
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Devin_Moores

Go To Solution

Best Answer

Best Answer

Answered By Devin_Moores 0 points N/A #106240

Saving changes is not permitted

Dear Simon

Instead of using Design feature of SQL Server Management Studio (SSMS) use the T-SQL. It may be possible that you might have changed few settings to the table insertions. Somehow SSMS takes different modules of displaying warning message and stops the end user from going further, and it will be resulted in preventing hanging of SSMS. I know that this feature can cause inconvenience in a situation when someone is required to save table using SSMS. When this kind of situation arises, then I would recommend to turn off this feature by going to Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation”.

Hope this solution will be helpful for you.

Regards

About Devin_Moores

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 05/08/2012
• Question Category: MS SQL Server

Answered By Norwood-Koonce 0 points N/A #195709

Saving changes is not permitted

Hello,

Once upon a time this problem is giving me lots of bothering. When I need to do some changes to table or something I had to re create the table with new modifications. Like that I have re created same tables many times.

Then I found this solution for that.

Go to Tools from you menu bar.

Then Option in that menu.

Now you can see a new window has opened.

In that window you can see a main menu called Designers.

Under that one there is a sub menu called Table and Database Designer. Select it.

Then remove the tick of Prevent Saving Changes that require table re-creation.

Press OK.

About Norwood-Koonce

Questions
0

Answers
96

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 05/08/2012
• Question Category: MS SQL Server

Answered By sam 40 points N/A #106241

Saving changes is not permitted

Hi Helenmarmstead,

You get that error because one of the following reasons:

–      You add a new column into the middle of table

–      Or you change a NULL column

–      Or you change the data type of a column

–      Or you change the orders of columns

–      Or you drop a column

In order to fix that error, do following step: go to Menu Tools > Options > Designers > uncheck the check box “Prevent saving changes that require table re-creation”

Hope this helps.

About sam

Questions
2

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/18/2013
• Question Category: MS SQL Server