다음을 통해 공유

  • 아티클

GetTransactionCount 메서드

데이터베이스에 대해 열린 트랜잭션의 수를 가져옵니다.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Function GetTransactionCount As Integer
‘사용 방법
Dim instance As Database
Dim returnValue As Integer

returnValue = instance.GetTransactionCount()

public int GetTransactionCount()

public:
int GetTransactionCount()

member GetTransactionCount : unit -> int 

public function GetTransactionCount() : int

반환 값

유형: System. . :: . .Int32
데이터베이스에서 열린 트랜잭션 수를 지정하는 Int32 값입니다.

주의

This method is useful when you change the snapshot isolation setting of the database to True, because the call can take a long time when there are long-running open transactions.

예

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")

'Display the number of open transaction on the database.
Console.WriteLine(db.GetTransactionCount.ToString)

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Write-Host $db.GetTransactionCount()