Database Mail

• Krish-853432

  SSC Veteran

  Points: 299

  More actions

  August 19, 2008 at 1:21 am

  #197056

  Hi,

  I am new to database mail in SQL 2005. can anyone guide me what are all the pre-requisites and the steps to send mail.

  Thanks & Regards,

  Krish

  Thanks & Regards,
  Krish.
  (Together We WIN)

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  August 19, 2008 at 1:27 am

  #859814

  Hello,

  This is a fairly good guide: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1322429,00.html#

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  August 19, 2008 at 2:59 am

  #859853

  [font="Verdana"]Checkout the link below

  Database Mail[/font]

  Regards..Vidhya Sagar
  SQL-Articles

• rajankjohn

  SSCertifiable

  Points: 5061

  More actions

  August 19, 2008 at 3:25 am

  #859858

  see if this helps you http://rajanjohn.blogspot.com/2008/04/using-database-mail-in-sql-server-2005.html

• Krish-853432

  SSC Veteran

  Points: 299

  More actions

  August 19, 2008 at 4:54 am

  #859883

  Hi,

  Nice articles.

  I have tried with the steps given in that articles. Messeges are queued, but not sent.

  Sent status is in "unsent" in sysmail_allitems table.

  Thanks & Regards,

  Krish.

  Thanks & Regards,
  Krish.
  (Together We WIN)

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  August 19, 2008 at 5:02 am

  #859893

  Hello,

  Try the troubleshooting guide in BOL. Under the topic "Troubleshooting Database Mail: Mail queued, not delivered" it specifically mentions mails with a status of "unsent".

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group