SQL User Audit | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL User Audit

Is there a way to audit a user and send email alert to a group when a user logs into sql server. I know this can be done by capturing data in profiler for the specific user and have a job that scans this data and use xp_sendmail to alert the dba.

Something like sp_who ‘login’? Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
May review links:
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.