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...

ah, I'm on 2008 to 2008 both 64bit

I had this issue.

Resolved it by adding myself as local admin on the SQL server I was connecting to. Reconnected to it with SSMS and I now had...

Hi. Thx for the quick response. I read that link earlier when I picked it up off a different thread. Very informative and helpful.

However, it did not seem to answer...