SP_ATTACH_DB

[sendba]

Hi all,

I am in a die hard situation.
Please help

I have a database where 2 tables are partitioned and the total number of data and log files in the db is 18.
There is a need to detach and attach the database once in every month which has to be automated

But the problem is detach works great but when i try to attach the dataase through Stored Procedure it fails.

Can someone let me know how to fix this issue.

thanks for your help

Sendba

 

[sendba]

I already figured out after i sent the email.

The feature in 2005 enables me to do that.

Create database db_name
primary datafile location
for attach

Thanks

Sorry guys