• 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.