exclusive control/

exclusive control/

 

  





Have RTFM'ed, but am still a bit unclear -

I'm gonna move a DB, and I'd like to get exclusive control first - I see
the "DBO use only option," and also the start in single user mode - the
thing is, SQL doesn't seem to have a facility to "stop" a single DB, and I
don't want to stop every DB on the server . .

DBO use only doesn't appear to bump current users off, either - is their a
simple, clean way to knock off any users and gain exclusive control of a DB
on SQL 7.0?


MS Sql Server LazyDBA home page