Hi,

it is when temporary tables are created because the server collation is different to the database collation. However, I've been looking at how to change the collation on the server and it is a pain. Changing the collation on the database looks easier but I'm not sure if changing the default then changes what already exists in the database, but I think not.

So... neither option looks like an easy option.