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.
  • 2293

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.