Ok, so at least we know [tempdb] is the correct collation. That would have been the only possible source of an error outside of whatever the actual query is doing. At this point you either need to get SQL Server Profiler working (you might need to install the client tools, though I have never seen that error so you should do a search on it), OR you can use extended events.