June 11, 2007 at 11:27 am
what is the best way to track sessiones, when a login connects to Sql 2000 and when sessiones ends.
I´m not sure if in a profiler task it could be record or maybe asking in a system table, we need to register all sessions conected and disconected inti Sql from several Sql 2000 Servers.
Thanks for any advice.
June 12, 2007 at 9:31 am
SQL Profiler (2000) you can add the Audit Login and Audit Logout event classes. This is more for a temporary monitoring.
For permanant monitoring here is an article covering C2 Auditing. C2 Auditing is resource hogging but will get you your login logouts http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx
You can also periodically run sp_who and find new entries that didn't exist before but its less effective.
-
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply