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 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)
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace