How to overcome an error message preventing you from saving a change in an SQL Server database
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.
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.