AttachDBFileName and then detach in code 1

[CP60]

I can use AttachDBFileName in an ADO connection in my application to attach a database to a SQL instance.

Also in code (VB), how can I detach the mdf again in order to move it to another location or even or delete it completely?

Thanks!

 

[CP60]

I can use oConn.Execute "drop database MyDB" to delete it completely.
But in code, how do just disconnect from the sql instance?

 

[gmmastros]

To detach a database...

https://msdn.microsoft.com/en-us/library/ms188031(v=sql.105).aspx

When executing this code, you should connect to the master database so things don't get weird with the connection.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[yelworcm]

To simply disconnect, you would use the Close() method of the Connection object. This will release the connection back to the connection pool in IIS, or close the connection to SQL for other types of applications.

 

[CP60]

gmmastros,

Thank you for that, it was just what I was looking for!

I connected to the 'master' DB and used:

Call oConn.Execute("EXEC sp_detach_db 'W:\Temp\SQL 2014\MyDB1.mdf', 'true';")
Call oConn.Execute("EXEC sp_detach_db 'MyDB2', 'true';")


Worked perfectly!


yelworcm, that is not what I meant. Sorry for the misunderstanding and making it clearer.