Disabling prevent saving changes that require the table re-creation in sql server 2008
SQL server Management Studio doesn’t allow the change to be done in table that need the table to be re-created.
Simple follow the following step to disable this feature:-
Go to Tools–>Options->Designers (un check the highlighted option)
Advertisements