.png)
Server.EnumProcesses Method (String)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public DataTable EnumProcesses ( String loginName )
public function EnumProcesses ( loginName : String ) : DataTable
Parameters
- loginName
A String value that specifies the login associated with the processes running on the instance of SQL Server.
Return Value
A DataTable object value that contains a list of processes running on the instance of SQL Server. The table describes the different columns of the returned DataTable.|
Column |
Data type |
Description |
|
Urn |
String |
The URN string that represents the process. "Server[@Name='PCNAME']/Process[@Spid='51']", for example. |
|
Name |
String |
The name of the process. |
|
Spid |
The SQL Server process ID that uniquely identifies the process. For more information, see sys.sysprocesses (Transact-SQL). | |
|
Login |
String |
The login running the process. |
|
Host |
String |
The name of the computer on which the process is running. |
|
Status |
String |
The status of the process. Running and sleeping, for example. |
|
Command |
String |
The command currently being executed. |
|
Database |
String |
The database is which the process is running. |
|
Cpu |
Int32 |
The cumulative time taken by the process in seconds. See sys.sysprocesses (Transact-SQL). |
|
MemUsage |
Int32 |
The number of pages in the procedure cache that are currently allocated to the process. A negative number indicates that the process is freeing up memory allocated by another process. |
|
BlockingSpid |
The SQL Server procedure ID of the procedure that is blocking the referenced procedure.. | |
|
IsSystem |
The value that specifies whether the process is a system process or not. | |
|
Program |
String |
The name of the program the process |
|
ExecutionContextID |
Int16 |
The ID value that uniquely identifies the execution context under which the process is running. |
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Call the EnumCollations method and return collation information to DataTable variable. Dim d As DataTable 'Select the returned data into an array of DataRow. d = srv.EnumCollations 'Iterate through the rows and display collation details for the instance of SQL Server. Dim r As DataRow Dim c As DataColumn For Each r In d.Rows Console.WriteLine("============================================") For Each c In r.Table.Columns Console.WriteLine(c.ColumnName + " = " + r(c).ToString) Next Next
