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.

Daca lucrezi cu SQL 2000, atunci e OK sfatul lui Bogdan.

Pe 2005, poti folosi un "compatibility view" - sys.sysprocesses. Dar, dupa cum spune BOL:

"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" - in cazul tau sys.dm_exec_sessions.

Gasesti "corespondenta" intre "system tables" si aceste "views" in BOL ---> Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views.

 

Inteleg ca sys.dm_exec_sessions este metoda recomandata.
Multumesc,

---

Ignat Andrei
http://serviciipeweb.ro/iafblog