Database.EnumTransactions Database.EnumTransactions Database.EnumTransactions Method

Definition

Enumerates a list of open transactions on the database.

Overloads

EnumTransactions() EnumTransactions() EnumTransactions()

Enumerates a list of open transactions on the database.

EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes)

Enumerates a list of open transactions of a specified type on the database.

EnumTransactions() EnumTransactions() EnumTransactions()

Enumerates a list of open transactions on the database.

public:
 System::Data::DataTable ^ EnumTransactions();
public System.Data.DataTable EnumTransactions ();
Public Function EnumTransactions () As DataTable
Returns

A DataTable object value that contains a list of open transactions that affect the database. The table describes the different columns of the returned DataTable.

Column
Data type
Description.
Name
String The name of the transaction.
TransactionID
String The ID value that uniquely identifies the transaction. See sys.dm_tran_active_transactions (Transact-SQL).
BeginTime
DateTime The date and time when the transaction started.
Spid
Int32 The session ID that uniquely identifies the session in which the transaction is running.
DatabaseName
String The name of the database in which the transaction is running.
DatabaseID
Int32 The ID value of the database in which the transaction is running.
DatabaseBeginTime
DateTime The date and time when the database came online.
IsVersioned
Boolean The Boolean value that specifies whether the transaction is a snapshot transaction and has a sequence number. See TransactionTypes enumeration class.

Examples

The example runs a Server object enumeration method, but extracting the information from the DataTable object is the same for Database enumeration methods.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = new-object System.Data.Datatable  
$d = $srv.EnumCollations  

Foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes) EnumTransactions(TransactionTypes)

Enumerates a list of open transactions of a specified type on the database.

public:
 System::Data::DataTable ^ EnumTransactions(Microsoft::SqlServer::Management::Smo::TransactionTypes transactionType);
public System.Data.DataTable EnumTransactions (Microsoft.SqlServer.Management.Smo.TransactionTypes transactionType);
Public Function EnumTransactions (transactionType As TransactionTypes) As DataTable
Parameters
transactionType
TransactionTypes TransactionTypes TransactionTypes

A TransactionTypes object value that specifies the type of transaction.

Returns

A DataTable object value that contains a list of open transactions that affect the database. The table describes the different columns of the returned DataTable.

Column
Data type
Description.
Name
String The name of the transaction.
TransactionID
String The ID value that uniquely identifies the transaction. See sys.dm_tran_active_transactions (Transact-SQL).
BeginTime
DateTime The date and time when the transaction started.
Spid
Int32 The session ID that uniquely identifies the session in which the transaction is running.
DatabaseName
String The name of the database in which the transaction is running.
DatabaseID
Int32 The ID value of the database in which the transaction is running. See sys.databases (Transact-SQL).
DatabaseBeginTime
DateTime The date and time when the database came online.
IsVersioned
Boolean The Boolean value that specifies whether the transaction is a snapshot transaction and has a sequence number. See TransactionTypes enumeration class.

Examples

The example runs a Server object enumeration method, but extracting the information from the <xref:System.DataTable> object is the same for Database enumeration methods.

VB

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = new-object System.Data.Datatable  
$d = $srv.EnumCollations  

Foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

Applies to