SQL 2005 db Tracking Users Statistics

[Mr.Access]

How can I generate tracking users statistics like ..

* No. of users?
* Who is online?
* Charts if possible ..
*...

Any ideas ?

Best Regards,

 

[datAdrenaline]

I would suggest you check out the results retruned by sp_who and sp_who2

In a passthru query from Access, you SQL property would look something like this ...

EXEC sp_who

or ...

EXEC sp_who2

You can then use the PT query objects as sources to other query objects and thus filter the results as you need to. Also, you can then use those results in graphs and such.

 

[Mr.Access]

Thank you datAdrenaline
but as someone told me that there's away to show clear and more
details of these two commonds.

I hope we can get it .
Regards,