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 Website Cloud Backup service can automate your database backups.   You have full control over backup retention and schedule.   DiscountASP.NET Website Cloud Backup - Everleap Website Cloud Backup