how do i count active users? i need to determine whether a database is still active? any other ideas here would also be useful. thanks!
u can use sp_who to see logins connected - but i need to count active individual users (not just logins, as could be using a windows group login) - is there any way?
See the script http://vyaskn.tripod.com/sp_who3.htm from this link, you can setup a scheduled job to run this script save to CSV file, then use SSIS package to pickup that file. How frequently and long you need this active users information?
