To allow you to save changes after you alter table, do following the steps:
- Open SQL Server Management Studio 2008.
- On the Tools menu, click Options.
- In the navigation pane of the Options window, click Designers.
- Uncheck the Prevent saving changes that require the table re-creation check box, and then click OK.