Saving Changes Is Not Permitted On SQL Server 2008 Management Studio

To allow you to save changes after you alter table, do disable prevent changes:

1. Open Microsoft SQL Server Management Studio 2008
2. Click Tools, then click Options
3. Click Designers
4. Uncheck prevent saving changes that require table re-creation
5. Click OK
6. Try to alter your table