November « 2009 « Dahlin Development

Call Today 320.281.0605

SQL Server 2008 – Saving Changes is not permitted.

November 19, 2009 Author: Joel

When trying to save a table when inserting a new column other than at the end I ran into this 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.

Solution:
In Management Studio, Tools –> Options then go to the Designer Page and uncheck “Prevent saving changes that require table re-creation”.

Solution found at: http://pragmaticworks.com/community/blogs/brianknight/archive/2008/06/04/sql-server-2008-designer-behavior-change-saving-changes-not-permitted.aspx