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 saving 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.

                                                                                                        codeproject.com

Posted in: SQL 2008