Saving changes is not permitted occurs when doing
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