Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Server.KillAllProcesses Method (String)

 

Stops the all processes on the specified database.

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

public void KillAllProcesses(
	string databaseName
)

Parameters

databaseName
Type: System.String

An String that specifies the name of the database.

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)
Return to top
Show:
© 2016 Microsoft