Stored procedure sending an email of results

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  May 23, 2006 at 3:09 pm

  #113808

  HI. I've been asked if it is possible to have a stored procedure execute and then have it email the summary of data it produced to a user. Can this be done and if so, how?

  Thanks so much,

  Juanita

   

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  May 23, 2006 at 3:26 pm

  #639613

  Absolutely (as long as you have MAPI correctly configured).  Have a look at xp_sendmail:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_6hbg.asp

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  May 24, 2006 at 8:17 am

  #639784

  Thank you so much! I think this is what we are looking for!

  Juanita