DBMail - query results in body or subject line

• dmitchell-851731

  SSC Journeyman

  Points: 81

  More actions

  February 24, 2010 at 1:05 pm

  #138447

  Hi there:

  Great resource here.

  I have just configured dbmail and would like to do a simple select count (*) script and have the results of the query be either in the subject line of the email or in the body (its a pain to open the attachment).

  Any help would be awesome.

  Thanks

  Dean

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  February 25, 2010 at 4:43 am

  #1124844

  Go to section c in this and give it a try. Let us know if you are stuck somewhere. Thanks.

  http://msdn.microsoft.com/en-us/library/ms190307(SQL.90).aspx

  ---------------------------------------------------------------------------------