Getting around the "MS SQL cant save after table change: Saving changes is not permitted" issue in Heidisql

iampatterson's profile image iampatterson posted 4 years ago in General Permalink

Ok so simple question.

I am logging in using my AWS RDS MSSQL using Root user. I am trying to update the data type in the table from say "int" to "varcar". It gives me an error Sql error 102 etc... I have narrowed it down to the problem of permissions. If I used Microsoft SQL Management Studio, and uncheck the "Prevent saving changes that require table re-creation, then I can make the change to the data type.

The question is how do I accomplish the same thing in Heidi SQL? Do I have to login using windows credentials? This means that I need a Domain controller. Is there a startup script that I can run. I am kinda lost as to what to do.

Please login to leave a reply, or register at first.