Saving changes is not permitted

SQL Server 2008 Error: Saving changes is not permitted

While Trying to update a table inside the database I'm working on(Which will happen alot of course), when I tried to save it... I encounter this annoying error.

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.

So I tried to Google the Problem... and the solution was quite simple.

http://www.danrigsby.com/blog/index.php/2008/09/26/sql-server-2008-error-saving-changes-is-not-permitted/

Tags: Modifying Table, SQL Server 2008

This entry was posted on Sunday, June 14th, 2009 at 12:04 pm and is filed under Database, MSSQL. 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.