Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Stops the all processes on the specified database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub KillAllProcesses ( _
databaseName As String _
)
'Usage
Dim instance As Server
Dim databaseName As String
instance.KillAllProcesses(databaseName)
public void KillAllProcesses(
string databaseName
)
public:
void KillAllProcesses(
String^ databaseName
)
member KillAllProcesses :
databaseName:string -> unit
public function KillAllProcesses(
databaseName : String
)
Parameters
- databaseName
Type: System.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)
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace