Automatically sending emails from sql server 2005 RSS

• • Reply
  

  RamchandraRe...

  None

  0 Points

  34 Posts

  Automatically sending emails from sql server 2005

  May 22, 2012 10:49 PM|LINK

  I have to send emails automatically from the sql server 2005 every 30days. Please any one help me this query.

  This is very need ful to me.

• • Reply
  

  harieis

  Participant

  782 Points

  242 Posts

  Re: Automatically sending emails from sql server 2005

  May 23, 2012 09:02 AM|LINK

  Hi,

  Better is create a windows service and connect with sql server.In the service we can set email sending functionality.

  thanks

  Please, Mark as Answer if this reply helped you
  Harikrishnan.S
  
• • Reply
  

  shabirhakim1

  Star

  13496 Points

  2145 Posts

  Re: Automatically sending emails from sql server 2005

  May 28, 2012 05:23 AM|LINK

  Hi

  just use SP for send an email and then create sql job to schedule it .

   

  http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/81b8a864-6823-41ec-8166-e1b7537c3867

   

  Regards

  shabir

  • Marked as answer by Young Yang - MSFT on May 31, 2012 02:39 PM