共用方式為

GetActiveDBConnectionCount 方法

傳回指定資料庫的使用中連接數目。

命名空間：  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

參數

傳回值

型別：System. . :: . .Int32
Int32 值，指定所指定資料庫的作用中連接數目。

備註

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("AdventureWorks2008R2"))

PowerShell

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

Write-Host $srv.GetActiveDBConnectionCount("AdventureWorks2008R2")
  • Last updated on