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 |
|
morrisos
Starting Member
10 Posts |
 Posted - 2003-05-20 : 14:42:59
|
| Hi, I am rather new to sql admin so I apologize if this is too easy.Is there an easy T-SQL way to determine who is currently logged into a database?Thanks, Morrisos |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-20 : 14:44:17
|
| Run sp_who or hit CTRL+1 in Query Analyzer. Also sp_who2.Tara |
 |
|
|
morrisos
Starting Member
10 Posts |
Posted - 2003-05-20 : 14:53:53
|
| thanks much. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-20 : 15:24:41
|
| That'll show everyone connected...if you want to see who doing things, try sp_who2 active. Sp_who2 will give you more info as well.Brett8-)Tara, didn't see the sp_who2 part...sorry. got to get new glasses 8-)Edited by - x002548 on 05/20/2003 15:25:58 |
|
|
|
|
|
|
Active User Database Connections