How can we detach /attach database in program?

[ad]

Can we detach /attach database in program?

 

[Miha Markic [MVP C#]]

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.

 

[Paul Clement]

¤ 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]

Thanks,
I am working with Sql2005 Express

 

[Cor Ligthert [MVP]]

Ad,

I don't believe that any one of us understand what you mean with.

Can we detach /attach database in program?

Do you mean Create/Alter/Drop?

Cor

 

[Miha Markic [MVP C#]]

Not sure about 2005 but in 2000 there are two stored procedures you might
use:
sp_detach_db and sp_attach_db