Upland Consulting Group

About the author

Author Name is someone.
E-mail me Send mail

Recent comments



The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2015

Saving changes is not permitted - Management Studio

Save not permitted in SQL Server 2008 - Management Studio
For those new to SQL Server 2008, you have probably got this message the first time you tried to change a table design.

"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 a table to be re-created"

When trying to change the columns in some tables, add columns or change null settings, you'll get the "Saving changes is not permitted" error and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file, not very useful.

The solution is pretty easy: Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".

Posted by ebarcza on Monday, October 12, 2009 11:12 AM
Permalink | Comments (0) | Post RSSRSS comment feed