Re: Is it possible to change tempdb? a collation problem

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 13:36:53 -0000

We have a similar issue on some systems where the collation at installation
has been incorrectly set relative to user databases, causing join errors
with temp tables. You can rebuild the system databases, as the other posters
point out, or when the temp tables are created, you can specify an explicit
column-level collation, thus overriding the tempdb default.
Rgds,
Paul Ibison

Relevant Pages

  • Thanks...
    ... > has been incorrectly set relative to user databases, causing join errors ... > with temp tables. ... > column-level collation, ...
    (microsoft.public.sqlserver.server)
  • Re: Collation advice going from 2000 to 2008
    ... it's more faster to change the actual create temp table statements ... than to change the existing collation of a database or to adapt the JOIN ... Sylvain Lafontaine, ing. ...
    (microsoft.public.sqlserver.server)
  • Transfering Database
    ... Transfering DB from one collation in SQL 2000 to a ... different collation in SQL 2000. ... We need to transfer our user databases from codepage 850 ...
    (microsoft.public.sqlserver.dts)
  • Re: Collation Conflict on Cross Database Join
    ... No need to create temp tables for this. ... What you need to do is to specify for one side of the JOIN ... > table a inner join table b ... the collation sequences on table a & b are different. ...
    (microsoft.public.sqlserver.programming)
  • Re: Collation advice going from 2000 to 2008
    ... Have you ever tried migrating a db with one collation onto a server ... if you have trouble with a temp table and a collation when making ... Sylvain Lafontaine, ing. ...
    (microsoft.public.sqlserver.server)