Dig further for a process (SPID) using Query Analyzer (SQL 2000 version specific) not DBCC INPUTBUFFER though.
Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific.
Within SQL 2000 to troubleshoot further about a SPID you can use:
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = <spid>
SELECT * FROM ::fn_get_sql(@Handle)