Thanks once again for your inputs...

EM as well as Query Analyzer was open when I was performing above. But, I don't think I was connected to Helpdesk DB.. It is...

I moved the datafile for one database. However, when I was trying run sp_detach procedure for other database I got following error:

Server Msg 3702 Level 16, State 1,. Line...

I forgot to mention that we are using SQL Server Version 7. I don't any of those options in SQL Server 7.

I was actually looking detach database option on SQL...

Thanks very much for the details.

But, it appears that the detach option is disabled on the Database. On right clicking the Database (e.g Master) in the EM I see detach...

Clive

Thanks very much...

I hv some queries regarding the same.

1) Can I move the datafile through Enterprise Manager

2) Do I have to move the datafiles before I deattah and attach using...