Exclusive use during restore - need answer asap

I'm trying to restore a database back to two nights ago. I
choose the backup I want and the force over existing
database option. It comes back with I need exclusive use
of db. How do I find out who else is on the db? I did
the sp_who active proc and the only one that shows up is
the sa account and me.
HELP!
Hi
If it is sa and you, that makes it 2. sp_who or sp_who2 are the correct SP's
to run. You need to get rid of the sa connection in able to restore the DB.
Cheers
Mike
"Edie Richardson" wrote:

> I'm trying to restore a database back to two nights ago. I
> choose the backup I want and the force over existing
> database option. It comes back with I need exclusive use
> of db. How do I find out who else is on the db? I did
> the sp_who active proc and the only one that shows up is
> the sa account and me.
> HELP!
>
|||"Edie Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:48d301c4a17c$928a2480$a501280a@.phx.gbl...
> I'm trying to restore a database back to two nights ago. I
> choose the backup I want and the force over existing
> database option. It comes back with I need exclusive use
> of db. How do I find out who else is on the db? I did
> the sp_who active proc and the only one that shows up is
> the sa account and me.
>
Don't do sp_who active as even inactive connections can be a problem.
Just use sp_who
(or select * from sysprocesses where dbid= your database id)

> HELP!