SQL Server 2008 – Saving changes is not permitted

Finally getting around to doing some work on SQL 2008, and after about 3 minutes, I run into this error: “Saving Changes is not permitted.. blah blah blah” See screenshot below.


This is different than SQL 2005. Microsoft maybe trying to save us from ourselves? The thing is, I never “enabled the option Prevent saving changes that require the table to be re-created” – it seems to be enabled by default. It would be awesome if this error told me exactly where the setting was.


Well, it happes to be in Tools->Options, Designers, Table and Database Designers. Uncheck the box and go about your merry way!



  • http://www.heritage.org/ Joe

    BooYa! Thanks a million!