Click here to Skip to main content
11,920,641 members (61,273 online)
Click here to Skip to main content
Add your own
alternative version


1 bookmarked

SQL Server 2008 Error: Saving changes is not permitted

, 22 Apr 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
How to fix this error.


SQL Server 2008 Error: Saving changes is not permitted.


While creating and editing a database in SQL Server 2008 I ran into a brick wall, or a 'by design' feature of the Database Management Studio.

When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes. This is caused by a configuration setting that results in the following dialog:

This dialog states: "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."

You can only react by clicking the Cancel button. And then Management Studio shows this dialog:

So what do you want to do to configure the setting with the value you want (should be the default setting!)?

Go to: Tools > Options 

“Designers –> "Table and Database Designers”

And uncheck the option: "Prevent saving changes that require table re-creation". Once you save the changes it will work.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Prasad CM
Software Developer (Senior)
India India
No Biography provided

You may also be interested in...

Comments and Discussions

GeneralThanks, Was searching for it Pin
Ritweek27-Oct-14 22:07
memberRitweek27-Oct-14 22:07 
QuestionAnnoying Pin
Member 439852516-Jul-13 12:19
memberMember 439852516-Jul-13 12:19 
GeneralMy vote of 5 Pin
kulinp30-Apr-13 22:40
memberkulinp30-Apr-13 22:40 
GeneralMy vote of 5 Pin
jeffpda27-Sep-12 11:52
memberjeffpda27-Sep-12 11:52 
GeneralMy vote of 5 Pin
saj_2110-Sep-12 4:10
membersaj_2110-Sep-12 4:10 
GeneralMy vote of 5 Pin
Member 888983928-Aug-12 4:48
memberMember 888983928-Aug-12 4:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.151120.1 | Last Updated 22 Apr 2012
Article Copyright 2012 by Prasad CM
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid