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."
Article ID: 996, Created On: 10/20/2011, Modified: 10/31/2011