SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

When making some datatable changes in db diagram environment, a popup window might show up with this message:

Saving changes is not permitted. The changes that 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./p>

meanwhile saving progress stops.

It is because that SSMS by default prevents some operations that requires target tables to be recreated. To go over this block, the highlighted item in Options window needs unchecking.

For more details refer the official knowledge base link:

Error message when you try to save a table in SQL Server 2008: "Saving changes is not permitted"

Published Sunday, April 4, 2010 2:59 PM by zc0000

Comments

# re: SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

Friday, April 16, 2010 5:53 PM by Adriano Rodrigues

Thanks for the tip!

# re: SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

Wednesday, June 16, 2010 4:00 AM by Hanakam

Great tip, was strugeling with this message.

# re: SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

Monday, May 16, 2011 4:49 PM by VnTim.Tk

That helps me.

Thank a lot.

# re: SQL SERVER 2008 Database Diagram: "Saving changes is not permitted"

Tuesday, January 28, 2014 11:06 AM by Guy

Awesome, thanks for posting this.

Leave a Comment

(required) 
(required) 
(optional)
(required)