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.