Click here to Skip to main content
Click here to Skip to main content

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.

Introduction

SQL Server 2008 Error: Saving changes is not permitted.

Solution

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.

License

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

Share

About the Author

Prasad C.M.
Software Developer (Senior) IGS
India India
No Biography provided
Follow on   Twitter

Comments and Discussions

 
QuestionAnnoying PinmemberMember 439852516-Jul-13 11:19 
GeneralMy vote of 5 Pinmemberkulinp30-Apr-13 21:40 
GeneralMy vote of 5 Pinmemberjeffpda27-Sep-12 10:52 
GeneralMy vote of 5 Pinmembersaj_2110-Sep-12 3:10 
GeneralMy vote of 5 PinmemberMember 888983928-Aug-12 3:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web03 | 2.8.141015.1 | Last Updated 22 Apr 2012
Article Copyright 2012 by Prasad C.M.
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid