Receive mail when specific user connects

• EA

  Mr or Mrs. 500

  Points: 521

  More actions

  February 22, 2007 at 12:28 am

  #115716

  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

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  February 22, 2007 at 3:36 am

  #691101

  I'm not sure if one of the database/server triggers can be used for this - haven't looked at this feature too much.  Is this for SQL or AD connects ?

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Rich Hansell

  SSCrazy

  Points: 2346

  More actions

  February 22, 2007 at 8:51 am

  #691185

  I believe SP2 includes Login Triggers that will fire on login

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  February 22, 2007 at 11:24 am

  #691226

  Look up

  "Trace Events for Use with Event Notifications"

  and

  "Designing Event Notifications"

  in Books Online.  I think you should be able to do what you want using that as a basis.  Haven't tried this myself though.