Export (0) Print
Expand All

Server.KillDatabase Method

Deletes the specified database and drops any active connection.

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

public void KillDatabase(
	string database
)

Parameters

database
Type: System.String
A String value that specifies the name of the database.

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Stop all processes running on the AdventureWorks database.
srv.KillAllProcesses("AdventureWorks")
'Stop the AventureWorks database.
srv.KillDatabase("AdventureWorks")
'Stop the specified process with ID 52.
srv.KillProcess(52)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft