Transaction Help For Auto-emailer

Here's the situation:





I want to automatically send someone an email with Licensing information. I save the license information in SQL with a EmailSent field that will have the date when the email is sent. But, I want to only make the update to the licenses table if the email is sent correctly/successfully. I currently use stored procedures for all upates to the database. But I don't use sql server's email facilities, rather I am emailing from C# code with the SmtpMail class. Sometimes wel will be mailing and saving a single license. Other times we will mail multiple licenses in the same email causing us to have to update multiple records in our Licenses table.





As far as I see it, here are my options:





1. Use automatic (COM+) transactions to call the SendEmails method and the License.Save method together. Write a Seperate SaveMultipleLicenses method.


2. Call License.Save or SaveMultipleLicenses method without updating the email sent field. Send the email. If it is successful update the email sent field.





Basically, I would like to know the best way to include the email methods within my transaction to update the database becuase we don't want to save a license (thereby indicating the customer has a license) unless the email is sent successfully.





Any advice would be greatly appreciated.





John Downing