Message: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.


To fix this SQL Server Management Studio 2008 message, please follow the directions below:
  • On the Tools menu, click Options
  • Expand Designers
  • Click Table and Database Designers 
  • Select or clear the Prevent saving changes that require the table to be re-created check box.

Add Feedback