Server.KillProcess-Methode

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
)

Parameter

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

Beispiele

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)

Siehe auch

Verweis

Server Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Aufrufen von Methoden

Verwalten von Servern

KILL (Transact-SQL)