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)