문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

Database.ActiveConnections 속성

Gets the number of active connections to the database.

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public int ActiveConnections { get; }

속성 값

유형: System.Int32
An Int32 value that specifies the number of active connections to the database.

The ActiveConnections property returns the active connections for the referenced database. Use the GetActiveDBConnectionCount method to return the total database connections on the instance of SQL Server.

VB

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

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

'Display the number of active connections to the database.
Console.WriteLine(db.ActiveConnections)

PowerShell

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

커뮤니티 추가 항목

추가
표시: