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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 how to check who is using the db?

Author  Topic 

mapperkids
Yak Posting Veteran

50 Posts

Posted - 2007-02-01 : 07:31:23
Hi,

Is there any way to tell me how many users connecting to specific database / who are using it in the management studio? we are use the windows authentication mode.

Thanks!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-01 : 07:38:13
sp_who


KH

Go to Top of Page
   

- Advertisement -