Columns have been added to the sysprocesses table. The sysprocesses table holds information about processes running on the SQL Server. These processes can be client processes or system processes.
These are the columns in the sysprocesses table.
| Column | Datatype | Description |
|---|---|---|
| last_batch | char(8) | The last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which SQL Server startup occurred is stored. |
| login_time | char(8) | The time at which a client process logged into the server. For system processes, the time at which SQL Server startup occurred is stored. |
| nt_domain | char(30) | The Windows NT domain for the client (if using integrated security) or a trusted connection. |
| nt_username | char(30) | The Windows NT username for the process if (if using integrated security) or a trusted connection. |
| net_address | char(12) | The assigned unique identifier for the network interface card on each user's workstation. When the user logs in, this identifier is inserted in the net_address column. |
| net_library | char(12) | The column in which the client's network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that allows them to make the connection. |