Knowledgebase: Databases
MS SQL Server 2008 - Saving Changes is not Permitted
Posted by Joe Rebis (Import) on 12 May 2009 10:47 AM

 

How to disable "prevent saving changes" option:

 

If you are currently using MS SQL Server 2008 Management Studio, you may receive the following error when attempting to make changes to a database table.

"Saving changes in not permitted. The changes you have made require the following tables to be dropped and recreated, 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."

 

NOTE: This option (prevent saving changes) is enabled by default.

 

To disable this option:

Click Tools >> Options >> Designers >> Table and Database Designers >> Uncheck "Prevent saving changes that require table recreation"

 

Once this has been disabled you will be able to make tables changes as anticipated.

 

SEE ALSO: Database Knowledge base Articles | "Important IP Addresses" knowledge base article

Contact Support

If you are still having issues, please contact us for further help.
1-877-EPHOST1 | support@ephost.com

 

 

(234 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright © 2015 EPhost, Inc. All rights reserved.