call web service from sql server 2008 R2

• anush_tar

  SSC Enthusiast

  Points: 181

  More actions

  June 10, 2012 at 6:59 am

  #270842

  Hi,

  I am wondering , if there a way to call web service from sql server and send emails, wich sends web service. Sql server just connecting to web service and tell him that it is time to send e mail.

  P.S: sorry for my English 🙂

• Thomas Stringer

  SSCarpal Tunnel

  Points: 4038

  More actions

  June 10, 2012 at 11:10 am

  #1499099

  It sounds like this could be a good usage of SQLCLR[/url].

  And you are sure that your design is solid with having the data-layer call a web service?

  ---

  
  Twitter: @SQLife
  Email: sqlsalt(at)outlook(dot)com

• corvette_454

  SSC Journeyman

  Points: 80

  More actions

  June 11, 2012 at 11:23 pm

  #1499586

  Hi,

  I think it's better to use the built-in Database mail features of MS-SQL

  http://msdn.microsoft.com/en-us/library/ms175887(v=SQL.105).aspx

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 12, 2012 at 1:18 am

  #1499611

  +1 for DBMail, why re-invent the wheel when its already there for you.