When I tried to save the table changes done using SQL Server
R2, I got the below error all the time.
The
problem was solved after the doing following changes.
To change the Prevent saving changes that require the table re-creation option, follow these steps:
- Open SQL Server Management Studio (SSMS).
- On the Tools menu, click Options.
- In the navigation pane of the Options window, click Designers.
- Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.
For more Info: http://support.microsoft.com/kb/956176