Sunday, March 21, 2010

[Prevent saving changes] SQL Server/Express 2008

Saving changes is not Permitted. The Changes you have made require the following tables to be dropped or 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 an annoying message that is prompted when trying to make changes to a table in SQL Server 2008/Express. While there can be many valid reasons for having this option [Prevent saving changes] switched on by default you would prefer to have this switched off during the implementation phase of the project.
Steps to disable the option [Prevent saving changes]

  1. Click on the Tools menu
  2. Click on Options of the Management Studio
  3. Click on the “Designers” tree
  4. Click on “Table and Database Designers”
  5. Uncheck “Prevent saving changes that require table-creation”
  6. Click “Ok”

No comments:

Post a Comment