• Article

Server.KillProcess Method

Stops the specified process.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub KillProcess ( _
    processId As Integer _
)
'Usage
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
)

Parameters

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

Examples

Visual Basic

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

PowerShell

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