Do an 'sp_who' , see which spid is connected , then use the kill command
to kill to terminate that session.......untill no one is connected.

Alternatively you can detach the database , move the files to the new
location and then attach the database.........after that run the
sp_change_users_login. This sp will reconcile the users in your moved
database to the local master database's sysusers table.

Good luck .

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Wednesday, November 26, 2003 4:31 PM
To: LazyDBA.com Discussion
Subject: 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?



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] information contained in this e-mail is confidential and may
be subject to legal privilege. If you are not the intended recipient,
you must not use, copy, distribute or disclose the e-mail or any
part of its contents or take any action in reliance on it. If you have
received this e-mail in error, please e-mail the sender by replying
to this message. All reasonable precautions have been taken to
ensure no viruses are present in this e-mail and the sender cannot
accept responsibility for loss or damage arising from the use of this
e-mail or attachments.
*****************************************************************************

MS Sql Server LazyDBA home page