Solution for “Saving Changes is not Permitted in SQL Server 2008 RC2 message

 

I was working with SQL Server 2008 R2 Version and I got hit by saving changes is not permitted …wwhhhaaattt?

 

image

 

image

 

Seems like you have to look around and find Tools—> Options

 

image

 

And you will find this

 

image

 

 

 

 

Look there is  the “Prevent Saving Changes that require Table re-creation”. Uncheck that box and you should be good to go.

Leave a Reply

Your email address will not be published. Required fields are marked *