[SQL Server] Saving changes is not permitted

To allow you to save changes after you alter table, Please follow these steps for your sql setting:

Open Microsoft SQL Server Management Studio 2008
Click Tools menu options, then click Options
Select Designers
Uncheck “prevent saving changes that require table re-creation” option
Click OK
Try to alter your table
Your changes will performed as desired