restoring databases

I want to restore a user database that is in use. Therefore the database mus
t
not be in use by anothet user.
1) How can I track the users using that specific database?
2) How can I send those users a messages using sql server?
3) How can I cancel their connections with that database?exec sp_who
within Query Analyzer
If they are using NT authentication you might be able to determine their
user account. You could then send them an email or you could try NET SEND.
ALTER DATABASE pubs SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE
Keith
"An Buysse" <An Buysse@.discussions.microsoft.com> wrote in message
news:5FEE0E06-2DA4-43A7-B003-9CB907F60ABB@.microsoft.com...
> I want to restore a user database that is in use. Therefore the database
must
> not be in use by anothet user.
> 1) How can I track the users using that specific database?
> 2) How can I send those users a messages using sql server?
> 3) How can I cancel their connections with that database?|||all of the three tasks you can do in Enterprise manager -> Management ->
Current Activity -> Process info.
Just right click on the process that you can see is using the database and
select the prefered option (Send message, Kill Process)
Danijel
"An Buysse" <An Buysse@.discussions.microsoft.com> wrote in message
news:5FEE0E06-2DA4-43A7-B003-9CB907F60ABB@.microsoft.com...
>I want to restore a user database that is in use. Therefore the database
>must
> not be in use by anothet user.
> 1) How can I track the users using that specific database?
> 2) How can I send those users a messages using sql server?
> 3) How can I cancel their connections with that database?