I know that in SQL 2000 you used to be able to do it, but I believe it was only possible one SPID at a time, and not part of a batch (notes below from BOL 2000).

Any particular reason you are staying in compatibility mode 8 and not moving to 9?

MS BOL 2000:

Database administrators can use the fn_get_sql function to help diagnose problem processes. After an administrator identifies a problem server process ID (SPID), the administrator can retrieve the SQL handle for that SPID, call the fn_get_sql function with the handle, and use the start and end offsets to determine the SQL text of the problem SPID. For example:

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52

SELECT * FROM ::fn_get_sql(@Handle)