Mail through sql server 2000
I have the table "Customer"
开发者_运维技巧It contains the fields - CustomerID,Email and ExpiryDate.
eg:
CustomerID Email ExpiryDate
1 aji@gmail.com 19/11/2010
2 john@yahoo.com 18/11/2010
3 Joseph@gmail.com 19/11/2010
I have to send an alert mail to all customers email ids whose expirydate is today.
How can I do it in sql 2000?
Install Sql Mail: https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/datacenter/?p=363
- SQL mail, requires a MAPI client, uses xp_sendmail
- Use the extended stored proc xp_smtp_sendmail for SMTP (not sure if supported now, YMMV)
- Last resort: use sp_OA% and cdosys
Or upgrade
精彩评论