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.
Deletes the specified database and drops any active connection.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Sub KillDatabase ( _
database As String _
)
'Usage
Dim instance As Server
Dim database As String
instance.KillDatabase(database)
public void KillDatabase(
string database
)
public:
void KillDatabase(
String^ database
)
member KillDatabase :
database:string -> unit
public function KillDatabase(
database : String
)
Parameters
- database
Type: System.String
A String value 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