Is is possible to get the sizes and/or number of rows of tables in the tempdb? I can see them in sysobjects, but sp_spaceused returns error 15009 (object does not exist). I read in a Sybase article the that some of numbers on the end of the table name relate to the SPID (maybe in hex). I haven't been able to work out if the same applies to SQL Server 2000. What I'd like to do is work our which process is causing the tempdb to grow so much, so either the SPID or the table name itself of the oversized tables will give some clues. Anyone got any ideas?