Have read most of the postings with regards to this but can seem to get it, currently unable to change DB collation because of the following error: Server: Msg 5075, Level 16, State 1, Line 1
The object ' ' is dependent on database collation. I have lots of objects, triggers, FK, PK, etc...
Not only do I need for the DB to change going forward but the data that is there as well.
Goal would be to:
Disable all objects
change db collation
change table collation
Is it possible?