How can we detach /attach database in program?

  • Thread starter Thread starter ad
  • Start date Start date
Hi,

You might execute proper DDL statement just like you execute selects or
inserts or whatever.
But of course, it depends on the database - some databases provide helper
objects.
 
¤ Can we detach /attach database in program?
¤

Could you be more specific? What kind of database(s) are you working with?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Ad,

I don't believe that any one of us understand what you mean with.
Can we detach /attach database in program?
Click to expand...

Do you mean Create/Alter/Drop?

Cor
 
Not sure about 2005 but in 2000 there are two stored procedures you might
use:
sp_detach_db and sp_attach_db
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detach sql files on closing? 1
detach database forcefully 1
How to recover SQL server database from corrupt mdf file? 3
Detach sql files on closing? 1
Detaching an object graph in EntityFramework? 1
How to close all connections of a database 1
SQL Questions: Attaching Databases to SQL Server 4
Detach database from SQL Server 4

Back
Top