When remotely connect to SQL Server and edit structure/design of a particular table, it doesn’t allow you to save the changes although it works fine if connect directly to the database server.
It produces an error message:
Saving changes is not permitted. The changes 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.
SQL Server Saving changes is not permitted
In order to deal with the issue, go to Tools => Options in the Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express.
SQL Server Prevent saving changes that require table re-creation
Expand Designers => Table and Database Designers, un check Prevent saving changes that require table re-creation option.
Finally, click OK button.
