How To Solve "Saving Changes Is Not Permitted" On SQL Server 2008 Management Studio

Problem: Saving changes is not permitted when doing alter table (table structure is changed):
1.       Change data type on existing columns
2.       Or change allow nulls on existing columns

Solution: To allow you to save changes after you 
alter table disable the prevent changes setting:
 
1.       Open Microsoft SQL Server Management Studio 2008
2.       Click Tools menu options, then click Options 
3.       Select Designers 
4.       Uncheck "prevent saving changes that require table re-creation" option
5.       Click OK
6.       Try to alter your table
7.       Your changes will performed as desired  

No comments:

Post a Comment