Save not permitted in SQL Server 2008 – Management Studio

For those who work with SQL Server 2008, you probably got this message, when trying to change the columns in some tables, add columns or change nullity conditions. “Save is not permitted”… 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.
The solution i found today is in SQL Books Online, and it is pretty easy:
Tools -> Options -> Designers, and uncheck the option “Prevent saving changes that require table re-creation”.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.