SQL Mail and SMTP

Question

SQL Mail and SMTP

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Bill Nye Hall of Fame Points: 3248 More actions · Answer 1

I recently wanted to do something similar. The following site provides great information on how to do this with an activex task, which can of course be scheduled. (Thanks to the Authors)

http://msdn.microsoft.com/msdnmag/issues/02/08/VBScriptandSQLServer2000/default.aspx

This will allow you to select data from a table to be inserted into the email, which can either be sent at regular intervals or when the table/data is updated.

Good luck.

Bill Nye, OCP

Bill

Corey Old Hand Points: 371 More actions · Answer 2

Another solution that I haven't seen posted here is to use the xp_smtp_sendmail extended sp. You can download the dll from http://sqldev.net/xp/xpsmtp.htm. All of the documentation for installation is provided there.

Corey Kilden DBA.