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

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

Date: Sun, 2 Jan 2005 14:28:01 +0200

Andrea,

Thanks for the answer.
I need a different collation as my sql setup is Latin1 and my specific DB is
Hebrew. While using temp tables in my DB I have a problem as the tempdb
doesn't understand Hebrew... Is there a solution for such problem?

Thanks,

I.P.

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:33q6rrF41pmbiU1@individual.net...
> hi I.P.,
> "I.P." <lafafa@yahoo.com> ha scritto nel messaggio
> news:cr8l1d$84e$1@news.iucc.ac.il
>> Hi,
>>
>> Is it possible to define another database to function as the tempdb
>> instead of the default tempdb?
>> I'm using sql2000
>>
>
> no, it's not possible unless you reinstall the SQL Server 2000 instance,
> as
> tmpdb collation is inherited from the system databases setting and is the
> same as master...
> you can not define an "alternative" user defined tempdb database...
> but, as SQL Server 2000 supports multiple collations both at database
> level
> and column level, you should not have this issue...
> why do you need a different collation?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

Relevant Pages

  • Re: Database collation error after moving to a remote sql server
    ... I think I'm going to try plan B: Install a second instance of SQL 2000 onto ... the remote server and set its default collation to the same as my SMS ... database, then move my db to the new instance. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)
  • Re: Case Insensitive lookup in DB
    ... Is your SQL Server installed with a case sensitive collation? ... And while you might be able to reset the collation of a database by using ...
    (microsoft.public.inetserver.asp.general)
  • RE: Install SQL Server 2000 with different COLLATION
    ... When you upgrade an existing SQL 7.0 instance, ... always inherits the 7.0 instance's collation. ... If you want to install SQL ... Microsoft SQL Server Support ...
    (microsoft.public.sqlserver.server)
  • Re: To unicode or not?
    ... Then again, since SQL Server stores Unicode data in the UCS-2 encoding, ... use them with varchar, you simply work with a subset of the characers, ... an SQL collation is just a Windows collation ...
    (comp.databases.ms-sqlserver)
  • RE: New Paper: Microsoft SQL Server Passwords
    ... Unfortunately changing the collation to case sensitive means that all the ... stored procedures and direct sql queries need to be case sensitive as well. ... are checked on non-production database before proceeding. ... > Subject: New Paper: Microsoft SQL Server Passwords ...
    (Bugtraq)