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)
 using enterprise manager to check the users

Author  Topic 

arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2007-12-17 : 23:56:53
How to check how many users are connected to a particular database and also where to look what are transactions which are being processed currently by a user

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-18 : 00:24:15
You can check those in activity monitor in ssms.
Go to Top of Page

arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2007-12-18 : 00:53:23
where can u find that activity monitor in ssms
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-12-18 : 01:39:19
in Object Explorer under the server/management/activity monitor


elsasoft.org
Go to Top of Page
   

- Advertisement -