TempDB is a system DB you can not rename it.What you
want to do is just restart SQL server if possible so
that it gets back to its default size.

--- Adil Basha <[Email Address Removed] wrote:
> Hi,
> sqlserver 7
> I am on production server
> My tempdb is occupying all the c drive space.
> tempdb.mdf
> How can i rename a tempdb
> Pls advise wht i should do
> Its urgent
>
> TIA
> Adil
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product
> search
> http://shopping.yahoo.com
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
MS Sql Server LazyDBA home page