I got the same problem.

A staging server is using collation_B and the Production server is using collation_A

Te staging server host a lot "unrelated with the problem" DB from other depts.

searching on web and at this very forum found 2 interesting articles:

http://www.sqlservercentral.com/articles/Collation/72182/

http://www.sqlservercentral.com/articles/Collation/70685/

As you can see it can be done but it's not simple.

If you got few DB a reinstall can be a option.

For me I considering to create a new instance with the correct collation and just move the few staging DBs to it

Hope it helps