Saving Changes Is Not Permitted On SQL Server 2008. How To Solve?

Saving changes is not permitted occurs when doing alter table (table structure is changed):

1. change data type on existing columns
2. or change allow nulls on existing columns

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

Hope this would be helpful.:)