Server.KillAllProcesses(String) Server.KillAllProcesses(String) Server.KillAllProcesses(String) Method

Definition

Stops the all processes on the specified database.

public:
 void KillAllProcesses(System::String ^ databaseName);
public void KillAllProcesses (string databaseName);
Public Sub KillAllProcesses (databaseName As String)
Parameters
databaseName
String String String

An String that specifies the name of the database.

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)  

Applies to