TEMPDB table do present problem in a mixed collation environment. The TEMPDB takes on the collation of the MSDB database every time the server is restarted. One option might be to set your MSDB collation to the most common collation used, therefore minimizing the issues with collations differences across databases.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples