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
 Development Tools
 Other Development Tools
 How many members access the same database

Author  Topic 

Mamatha
Posting Yak Master

102 Posts

Posted - 2005-01-28 : 02:30:46
Hi

SQL Server database is used by more than one member at same time,and i want to know how many members access same database. Is there any command for that.Please give me the solution.

Mamatha

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-28 : 15:27:29
sp_who will show you the current activity of the system. This stored procedure uses master.dbo.sysprocesses.

Tara
Go to Top of Page
   

- Advertisement -