Collation error

@Sameer I know you said that the system was set to the correct collation, but just to be sure, please let us know the result from the following query:

SELECT db.[collation_name]
FROM   sys.databases db
WHERE  db.[name] = N'tempdb';