Dacă vorbim de SQL2000 şi/sau SQL2005 atunci sysprocesses.
Dacă e vorba de SQL >= 2005 atunci se recomandă sys.dm_exec_sessions.

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views.