disconnect one or more users 2

[seaport]

How do I disconnect one user from one database? and how do I disconnect all users from one database so I can enable single user option to this database?

Thanks in advance.

seaport

 

[tlbroadbent]

You can get a script at the following link.

Quickly Disconnecting Users

http://www.swynk.com/friends/knight/killusers.asp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[seaport]

Thanks, Terry,

I accidentally found an easy way to accomplish the job. In the enterprise manager, I click the menu item to detach the database. In the confirmation box, there is a button to disconnect all users. I can use this button.

Of course I do not have to detach the database and just click "Cancel" after I disconnect all users.

seaport