Code Snippet for detaching SQL database in vb.net
In this article we are going to explain Code Snippet for detaching SQL database programmatically in vb.net.
Code Snippet for detaching SQL database programmatically in vb.net
Dim conn As SqlClient.SqlConnection
Dim cmd As New SqlClient.SqlCommand()
Dim ConnectionString As String = "Data Source=" & Server name & ";Initial Catalog=master;Integrated Security=True" ' Connection string
conn = New SqlClient.SqlConnection
conn.ConnectionString = ConnectionString
conn.Open() 'Open connection
Dim sqlDetech As String = "sp_detach_db '"& database name &"', 'true'" ' Sql query for detaching database
cmd.CommandText = sqlDetech
cmd.Connection = conn
cmd.ExecuteNonQuery() 'execute query