• Article

ServerConnection.TransactionDepth Property

Gets the current transaction depth for the referenced connection.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public ReadOnly Property TransactionDepth As Integer
    Get
'Usage
Dim instance As ServerConnection
Dim value As Integer

value = instance.TransactionDepth

public int TransactionDepth { get; }

public:
property int TransactionDepth {
    int get ();
}

member TransactionDepth : int

function get TransactionDepth () : int

Property Value

Type: System.Int32
An Int32 value that specifies the current transaction depth for the referenced connection.

Remarks

A connection can experience nested transactions. The transaction depth refers to the number of nested transactions.

Examples

C#

ServerConnection conn = new ServerConnection();
Console.WriteLine(conn.TransactionDepth);

PowerShell

$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection
Write-Host $conn.TransactionDepth