开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜