In SQL Server 2008, you might have gotten this message when trying to change the columns in some tables, add columns or change nullity conditions. “Save is not permitted” 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, which is, i think, not very useful .
Here is the solution:
Tools -> Options -> Designers, and unchecked the option “Prevent saving changes that require table re-creation”.

One Response to “Save is not permitted in SQL Server 2008”

  1. Özgür S. says:

    Thanks for the tip. It worked!

RSS
Copyright © 2010 Islander’s Analog life…. All rights reserved. Amazing Grace theme by Vladimir Prelovac.