Re: Is it possible to change tempdb?

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 13:13:45 +0100

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

  • Turkish character problem in SQL Server 2000
    ... I'm trying to migrate a Sybase SQL Anywhere database to SQL server 2000. ... have a problem when I choose "Turkish_CI_AS" as the database collation: ... When I use lowercase Ithere's no error. ...
    (microsoft.public.sqlserver.programming)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... You cannot set the recovery model in tempdb. ... Columnist, SQL Server Professional ... We would then have to issue an alter database ...
    (microsoft.public.sqlserver.server)
  • Re: db library error ?
    ... Tibor Karaszi, SQL Server MVP ... > the following error message apeared: ... > The log file for database 'tempdb' is full. ...
    (microsoft.public.sqlserver.server)
  • Re: sql2k Collation problems.
    ... > Mixed Collation Environments ... > *The tempdb database is built each time SQL Server is started, ... > different default collation than tempdb. ... All temporary stored procedures ...
    (microsoft.public.sqlserver.setup)
  • Re: Database collation error after moving to a remote sql server
    ... > I've recently my SMS 2003 database to a remote sql server (it was ... > Server]Cannot resolve collation conflict for equal to operation. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)
Loading