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?