Saving changes not permitted MSSQL 2008
"Saving changes not permitted"
This kept coming up when I tried to change column attributes and re-arrange column orders for a table that existed.
It was odd I could make schema changes like this with SQL 2005 why not 2008?
Turns out its a simple setting that's on by default in the SQL 2008 Enterprise manager ( Express and Full ) and João Fernandes gave me the solution over twitter only a few mintues after I asked.
Here are the exact steps:
Click "Tools" , Select "Options", Expand "Designers", select "Table and Database Designers" then deselect "Prevent saving changes that require table re-creation"
Cras justo odio, dapibus ac facilisis in, egestas eget quam. Curabitur blandit tempus porttitor. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor.