SQL Server Management Studio error: Saving changes is not permitted

If you receive the following error after trying to make changes to your tables in SQL Server Management Studio using the graphical table designer, it is due to a client side setting:





To correct the problem, click on Tools -> Options in SQL Server Management Studio and select "Designers."  Make sure the Prevent saving changes that require table re-creation option is UNCHECKED and click "OK."


Our Cloud Backup service can automate your database backups. You have full control over backup retention and schedule. DiscountASP.NET Cloud Backup - Everleap Cloud Backup