I've 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.
My problem is that I'm using a DBLayer which doesn't easily expose the
Collation properties of the underlying columns.
Try using the "collate" clause.
select c1 collate database_default as c1
Thank you. I'll give that a try