Error Message: Saving Changes Is Not Permitted

Introduction

When a change is made directly into a table, there might be cases where saving isn't possible. This tip explains the reasons and the possible actions to take in such cases.

Background

SQL Server Management Studio is a powerful tool which can allow accessing and changing database even if they are currently used. In many cases, you will be the one using the database, as part of an ongoing development so there is no risk recreating tables or even deleting data. In such case, you can avoid such error messages each time you want to make a change.

The Error Message

When you make a change in a table, which requires the table to be recreated, you might see the following error message:

How To Avoid It

Go to Settings. Then go to Designers. You will see the "Prevent saving changes that require table re-creation" setting checked. Uncheck it and press OK. 

Now you can make changes in tables and queries without getting this error message.