|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > sp_who
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Wilson 2002-10-05, 9:09 pm |
| Hi,
While I was restoring a database, server prompted saying it could not get
exclusive connections. But when I used sp_who to check I could not find any
connections. Again I tried the same happening.
Any other way to check othen than "sp_who"? Or any bug?
Thanks in advance
Wilson
| |
| Tibor Karaszi 2002-10-05, 9:09 pm |
| Make sure that the connection where you do the restore from isn't in the database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Wilson" <wilsontc@singnet.com.sg> wrote in message news:u9fO3wSXCHA.360@tkmsftngp12...
> Hi,
>
> While I was restoring a database, server prompted saying it could not get
> exclusive connections. But when I used sp_who to check I could not find any
> connections. Again I tried the same happening.
>
> Any other way to check othen than "sp_who"? Or any bug?
>
> Thanks in advance
>
> Wilson
>
>
>
|
|
|
|
|