sending email with SQL

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  November 5, 2007 at 1:53 pm

  #748408

  Hi David, database mail in MSSQL 2005 does not require any MS Office components, just connectivity to your SMTP relay.

  Tommy

  Follow @sqlscribe

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  November 6, 2007 at 5:14 am

  #748595

  maybe http://www.sql-server-performance.com/da_email_functionality.asp can help out.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• krishan kumar joshi

  Newbie

  Points: 9

  More actions

  December 26, 2008 at 2:02 pm

  #917930

  Hello,

  I am also getting same problem, so many time mail are stuck in Q when i restarted SQL server. I am getting all pending.

  Please help on them, what is root cause and why this happen.

  Krishan

• amirzainab

  SSC Enthusiast

  Points: 109

  More actions

  February 10, 2009 at 2:55 am

  #941036

  Hi,

  I faced the same problem and could solve it with the following

  Went to Server Agent Properties, then Alert System, Enable Mail Profile "Database Mail".

  Then to History and checked on Delete job history.

  Stopped and Restarted SQL Server Agent and it worked.

  I hope this helps.

  Regards

  VaishaliHusain