Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cedtech31
Starting Member
17 Posts |
 Posted - 2008-06-04 : 13:32:13
|
| I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.can this be done in SQL and if so how? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 13:36:59
|
| You can find out who is connected with sp_who/sp_who2/master.dbo.sysprocesses. You can disconnect users with the KILL command.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
list users then disconnect users