Is it possible to change tempdb?

Hi,
Is it possible to define another database to function as the tempdb instead
of the default tempdb?
I'm using sql2000
Thanks,
I.P.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.shtmhttp://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