- Plesk 12.0 for Windows
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.
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 .
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.