number of users connected to a SQL Database

[E. W via DotNetMonster.com]

Hi all,
is it possible to get the numer of users, who are connected at the same time
to the specified SQL Database and how do I get this Information?
thanks
EW

 

[imperugo]

you have to run a stored procedure sp_who.

more details:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_wa-wz_3v8v.asp

byez

sorry for my english

 

[Craig Scheets]

....Or use the PerformanceCounter provider in Windows. It reports a TON of
information about SQL including of course concurrent users. I actually
develop on a package that does this if you have a need to do it for the
enterprise. http://www.CanyonNetworks.net .

Craig

 

[E. W via DotNetMonster.com]

Thank you, it seems to fit my needs if hostname is the PC-name of the
connected user.
Your english is as good as mine, I am german.
EW