be aware that a field in a table can have a different collation than the default collation for a database.

1) find the query/command causing the trouble

2) check all the fields and their collation

3) check also the collation of tempdb

There is also a Collate command, but I haven't used it yet except for scripting tables.