Unanswered: Receive mail when specific user connects
I want to receive a mail when a specific user connects.
How can this be done best? Raise an alert? How?
Btw, the 'Login auditing' is set to 'Failed logins only'.
Suggestions are very welcome!
u can scan master..sysprocesses table periodacally to check if that user has connected by matching sid with sid of syslogins table. a job can send u the mail, if not as soon as the user connects (depends on the frequency of the job) ... there might be a better option not sure...