"Detach databse" Option is grayed... 2

[davidchardonnet]

Hello,

I want to move my SQL Server database to another hard drive. I searched on this forum and I saw a thread where I read it was necessary to detach the database. But When I have a look at this option, it appears to be grayed, and inaccessible.

Do you know what I am missing to do that?

Thank you

David

 

[nigelrivett]

Are you the database owner or sysadmin?

Try
sp_detach_db dbname
in query analyser and see what the response is.

And try not to rely on enterprise manager too much - you will gain a lot more by using t-sql.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[davidchardonnet]

Okay I could detach and move the files. Thanks!!
Now What do I have to do to attach it?

 

[nigelrivett]

Look at
sp_attach_db
or
sp_attach_single_file_db
in bol.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Corran007]

If you were able to detach with tsql but not enterprise manager, you were proably looking at a sql7 database with sql2k enterprise manager.

 

[davidchardonnet]

Corran007 that's exactly right!!

 

[davidchardonnet]

Thank you nigelrivett, i could do what I want thanks to your advices!!!