Saving not permitted in SQL Server Management Studio 2008

"Saving changes is not permitted. The changes you have made require the following tables to be dropped ..."

I found that this is one of the most annoying default settings I ever saw in a development tool.
In this dialog you can save the text to a text file (not very helpful here) or cancel the save action of the item you are working on.

To prevent SQL Server Management Studio 2008 to show that message while you are developing a database schema go to the Options.
Tools -> Options -> Designers -> Table and Database Designer and uncheck the "Prevent saving changes that require table re-creation".


Posted Sep 04 2008, 09:01 PM by alehmann
Filed under:

Comments

Haha wrote re: Saving not permitted in SQL Server Management Studio 2008
on 01-07-2009 10:20

Thanks for your helping

Xavier wrote re: Saving not permitted in SQL Server Management Studio 2008
on 01-08-2009 15:57

THANK YOU!! and yes it is EXTREMELY annoying

Knusi wrote re: Saving not permitted in SQL Server Management Studio 2008
on 06-20-2009 17:02

THANKS!!!!!!!!!!!!!

developers.de is a .Net Community Blog powered by daenet GmbH.