共用方式為


Server.KillProcess 方法

Stops the specified process.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub KillProcess ( _
    processId As Integer _
)
'用途
Dim instance As Server 
Dim processId As Integer

instance.KillProcess(processId)
public void KillProcess(
    int processId
)
public:
void KillProcess(
    int processId
)
member KillProcess : 
        processId:int -> unit
public function KillProcess(
    processId : int
)

參數

  • processId
    型別:System.Int32
    An Int32 that specifies the system ID value that uniquely identifies the process.

範例

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Stop all processes running on the AdventureWorks2012 database.
srv.KillAllProcesses("AdventureWorks2012")
'Stop the AventureWorks database.
srv.KillDatabase("AdventureWorks2012")
'Stop the specified process with ID 52.
srv.KillProcess(52)

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$srv.KillAllProcesses("AdventureWorks2012")
$srv.KillDatabase("AdventureWorks2012")
$srv.KillProcess(52)

請參閱

參考

Server 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

呼叫方法

管理伺服器

KILL (Transact-SQL)