Changing Collation with a High Availability server
I have to remove the DB from High Availability Group(Always on), change the DB to single user, change the collation then change it back to multiuser,back to the high availability group. The good thing is this database is new and it only have 5 tables otherwise it will be more complicated. I was just hoping I don't have to remove it from the group.