Aracılığıyla paylaş


Server.KillProcess Method

Stops the specified process.

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

Syntax

'Bildirim
Public Sub KillProcess ( _
    processId As Integer _
)
'Kullanım
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

Server Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Calling Methods

Managing Servers

KILL (Transact-SQL)