yadavdep
asked on
Call a web service from Sql Server 2012 stored Procedure
I have few stored Procedures which run some query and based on the result send mail to clients.
Now my client has added a web service in his company which sends mail to customers.
He wants me to use this service inside the store procedure and send mail through this web service.
I need to know what would be the best option for me here to call this service for sending emails.
Should I go for SQL CLR and UDF?
Now my client has added a web service in his company which sends mail to customers.
He wants me to use this service inside the store procedure and send mail through this web service.
I need to know what would be the best option for me here to call this service for sending emails.
Should I go for SQL CLR and UDF?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.