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

Language

Home>Knowledge Base>Databases>SQL Server>Message: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Information

Article ID	119
Created On	11/18/2009
Modified	11/18/2009

Actions

Print this Page

Add Favorite

Share With Others

	Digg
	Reddit
	del.icio.us

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.

Management Interface