tags:

views:

38

answers:

1

When i am going to change the data type of column name i am getting these error,,Can you tell me the solution

Saving changes is not permitted.The changes you have made require the following .You have either made changes to a table that can't be created or enabled the option Prevent saving changes that require the table to be re-created ..Where can i find the option "Prevent saving changes that require the table to be re-created"

+3  A: 

You can find this in Tools -> Options -> Designers in SQL Server Management Studio.

Ronald Wildenberg
Should be the second last check box on that dialog
RobS
thanks ,,when i disable that option that problem over
peter