"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