Follow us

Wednesday, March 2, 2011

MS SQL Troubleshoot #1 :: Saving changes is not permitted

Error

Saving changes is not permitted. The changes that 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.

Reason

The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created:

  • Adding a new column to the middle of the table
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column

Troubleshoot

On the Tools menu, click Options , expand Designers , and then click Table and Database Designers . Uncheck / clear the Prevent saving changes that require table re-creation check box. click OK to save changes

Troubleshoot :: Saving changes is not permitted


Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

0 comments: on "MS SQL Troubleshoot #1 :: Saving changes is not permitted"

Post a Comment