Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    1

    Unanswered: Receive mail when specific user connects

    Hi,
    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!
    Cheers,
    E

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •