Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tribune
Posting Yak Master
105 Posts |
 Posted - 2005-09-30 : 03:24:39
|
| Hi all, it's been a while since I last posted here! Basically, I have a bunch of web services that send out emails to customers using certain templates for new orders, order cancellations, past due notices, thank you letters, et cetera. The web services generate these emails and are responsible for sending them.The problem I have is that although most of these services can be called from within my ASP.NET website through asynchronous web service calls (as a result of user actions - for example, after a user places an order), sometimes emails may not be sent, if for example the SMTP server is down.What I'd like to do is have SQL Server automatically call these web services for me, and catalog if the email was sent successfully or not.Of course, I could have a standalone application running 24/7 which scans the database and calls the web services, but I'd rather integrate this functionality into SQL server.Can I do this in SQL 2005? Or, would you recommend I take advantage of CLR integration in sql server and take the code from my web services and create my own procedures and send the emails directly from SQL Server?If you have any links that would help me out i'd appreciate it too.Thanks |
|
|
|
|
|
|
|
Calling web services from SQL server 2005