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.