I have just come up against the issue of the tempdb's collation can end up being different dependent upon whether you SELECT INTO or CREATE TABLE. I was wondering whether there was a function I could call on certain columns of the SELECT INTO which would force the collation to be something other than the TempDB's default collation.