As with virtually all headlines containing a question, the short answer is no. From the research I have done, the temp table will always be created with the collation of the SQL Server. If you want to skip to the solution, click here.
Why would you want a different collation? Well, in this case we need a different collation as there is a third party database which a customisation in…
Continue Reading Ian Grieve’s Article on their blog
Can I Create a Temp Table With Collation Different to the Server Collation? – azurecurve
Blog Syndicated with Ian Grieve’s Permission