Tuesday, June 16, 2009

SQL Server 2008 Annoying warning when saving changes : Saving Changes Not Permitted

When I started working with SQL server 2008 express edition I got a new message that I have not seen in previous versions of SQL Server. The designer does not allow to save table changes like before.

This is the warning message:

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.
After searching at the options menu I noticed you can disable this warning by unchecking the "Prevent saving changes that require table re-creation".

Since it's a warning message there is a way to remove this simply by unchecking an option in the Tools -> Options -> Designer menu context.
Uncheck the option
"Prevent saving changes that require table re-creation"

This will take care of the issue.

No comments:

Post a Comment