Thanks...

From: I.P. (lafafa_at_yahoo.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 15:34:33 +0200

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:Oi8B48M8EHA.2572@tk2msftngp13.phx.gbl...
> 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

  • Re: Is it possible to change tempdb? a collation problem
    ... 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. ...
    (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)