SQL Server 2008 - Saving changes is not permitted

SQL Server 2008 – Saving changes is not permitted

I recently started using SQL Server 2008, at first it was really nice, but then I started getting a weird error every time I tried modifying a table.

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

This is really annoying because you cannot add relationship to your tables once your created them! Luckily all we need to do to correct this error is change an option in SQL Management Studio.

Go to Tools » Options » Designers and Uncheck “Prevent saving changes that require table re-creation”

That should do the trick!

Submit Article :- BlinkList + Blogmarks + Digg + Del.icio.us + Ekstreme Socializer + Feedmarker + Furl + Google Bookmarks + ma.gnolia + Netvouz + RawSugar + Reddit + Scuttle + Shadows + Simpy + Spurl + Technorati + Unalog + Wink

Posted in: SQL Server

This entry was posted on Monday, September 15th, 2008 at 10:25 pm and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.