tempdb size increases

I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at a
alarming rate and now it is at about 2GB. Is there a way to view what is in
the tempdb?

You can look inside the sysobjects table of tempdb to see what objects are
being created

ie

select * from tempdb..sysobjects



"Tom Reis" <reistom@cdnet.cod.edu> wrote in message
news:efL38NP9FHA.3532@TK2MSFTNGP14.phx.gbl...
> I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at
a
> alarming rate and now it is at about 2GB. Is there a way to view what is
in
> the tempdb?
>
>

Use GOOGLE.  This question has been posted a million (milliard) times
before!

"Tom Reis" <reistom@cdnet.cod.edu> wrote in message
news:efL38NP9FHA.3532@TK2MSFTNGP14.phx.gbl...
>I have a SQL 2000 Server with SP4 where the tempdb seems to be growing at a
> alarming rate and now it is at about 2GB. Is there a way to view what is
> in
> the tempdb?
>
>