Saving changes is not permitted occurs when doing
alter table (table structure is changed):
- Change data type on existing columns
- Or change allow
nulls 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
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
