My Writings. My Thoughts.

SQL Server 2008 - Can’t save changes!

// March 9th, 2009 // .Net, SQL Server, Troublesolving

When using the SQL Server 2008 Management Studio I bumped into the following message while creating some new tables: “Saving changes are not permitted”.

Error Message

Error Message

Now, a warning that this is happening is just dandy, but totally preventing me from performing it was not what I expected. To get around the “problem” you need to disable an option. Simply select “Tools->Options”, then “Designers”, and finally uncheck the option “Prevent saving changes that require table re-creation”.

Options

Options

Ohh well, where was I now…

No TweetBacks yet. (Be the first to Tweet this post)

Leave a Reply