Server.GetActiveDBConnectionCount 메서드
Returns the number of active connections for the specified database.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Function GetActiveDBConnectionCount ( _
dbName As String _
) As Integer
‘사용 방법
Dim instance As Server
Dim dbName As String
Dim returnValue As Integer
returnValue = instance.GetActiveDBConnectionCount(dbName)
public int GetActiveDBConnectionCount(
string dbName
)
public:
int GetActiveDBConnectionCount(
String^ dbName
)
member GetActiveDBConnectionCount :
dbName:string -> int
public function GetActiveDBConnectionCount(
dbName : String
) : int
매개 변수
- dbName
유형: System.String
A String value that specifies the name of the database.
반환 값
유형: System.Int32
An Int32 value that specifies the number of active connections for the specified database.
주의
This method returns the number of active connections to a database. By iterating through all the databases on the instance of SQL Server, you can determine the total number of connections to databases on the instance of SQL Server.
예
Visual Basic
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server()
'Display the number active connections to the database.
Console.WriteLine(srv.GetActiveDBConnectionCount("AdventureWorks2012"))
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host $srv.GetActiveDBConnectionCount("AdventureWorks2012")
참고 항목
참조
Microsoft.SqlServer.Management.Smo 네임스페이스