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






4.94/5 (39 votes)
How to solve when saving changes is not permitted on SQL Server 2008 Management Studio
Saving changes is not permitted occurs when doing
To allow you to save changes after you
alter table
(table structure is changed):- Change data type on existing columns
- Or change allow
null
s on existing columns
To allow you to save changes after you
alter table
, do disable prevent changes:- 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