I was working with SQL Server 2008 R2 Version and I got hit by saving changes is not permitted …wwhhhaaattt?
Seems like you have to look around and find Tools—> Options
And you will find this
Look there is the “Prevent Saving Changes that require Table re-creationâ€. Uncheck that box and you should be good to go.
Category: Information Technology