sp_detach_db [dbname =] 'dbname'
[, [skipchecks =] 'skipchecks']
exec sp_detach_db 'Northwind' will detach Nortwind database.
Details in BOL.
"Terry Holland" <londontelhotmail.comic> wrote in message
news:u$mADkgRDHA.704tk2msftngp13.phx.gbl...right-click> Forgot to mention its Version 7
> "Terry Holland" <londontelhotmail.comic> wrote in message
> news:ex5I6egRDHA.2148TK2MSFTNGP11.phx.gbl...> > I wan to detach a database but the option is greyed out when I>> > /All Tasks the database in EM.
> > How do I detach in this situation?
> > --
> > tia
> > Terry Holland
> > Nikori Systems