Wednesday 13 February 2013

MS SQL - How to fix error - Saving changes is not permitted.

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 recreated or enabled the option Prevent saving changes that require the table to be re-created.

to fix it go to tools options designers and uncheck Prevent saving changes that require table re-creation.

No comments:

Post a Comment