Home Forums Article Discussions Article Discussions by Author Discuss content posted by Edward Elliott What is sysprocesses and what can it do for you? RE: What is sysprocesses and what can it do for you?
SanjayAttray
SSChampion
Points: 13157
More actions
May 1, 2009 at 7:44 am
#987303
Good review of sysprocess table. Every DBA should know about this table. Though I know a couple of ones who are used to using sp_who2 but does have no idea where the data comes from.
2005 and 2008 has an extra column request_id.
SQL DBA.