Changing the data type of a column in MSSQL database fails with warning: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created.

Created:

2016-11-16 12:45:39 UTC

Modified:

2017-08-08 13:30:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Changing the data type of a column in MSSQL database fails with warning: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created.

Applicable to:

  • Plesk 12.0 for Windows

Symptoms

Changing the data type of a column in MSSQL database fails with warning:

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.

Cause

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. Please refer to Microsoft article .

Resolution

Follow recommendation and disable (Not Permitted) dialog: click in MSSQL Studio Management->Tools->Options . expand Designers , and then click Table and Database Designers . Select or clear the Prevent saving changes that require the table to be re-created check box.

Have more questions? Submit a request
Please sign in to leave a comment.