I am making an application interacting with Exchange Server. So, my database
is going to store e-mails which also has some datetime column like DUEDATE.
Now, what I hv to do is to send reminders to customers like after 5 date its
ur due date, and like today ur due date has ended and u hv been penalized.

peace
rohit

-----Original Message-----
From: Brian Freeman [mailto:freeman@C...]
Sent: Tuesday, January 28, 2003 10:42 PM
To: sql language
Subject: [sql_language] RE: Database Trigger? E-MAIL??


There may be a better way than using a trigger and xp_sendmail.  There are
several questions that will help determine that.  What are you wanting to
achieve?  It might be easier to send an e-mail from the ASP page instead of
using xp_Sendmail.  What will be writing the data to the table?

Brian Freeman
(xxx) xxx-xxxx  ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

-----Original Message-----
From: Rohit Arora [mailto:rohit_arora@i...]
Sent: Tuesday, January 28, 2003 9:37 AM
To: sql language
Subject: [sql_language] Database Trigger? E-MAIL??


Hi Group,

I am working on ASP.NET application, with backhand SQL SERVER 2000. Can I
write a trigger which which check a datetime column of a table and SEND AN
E-MAIL ? If yes, then how ? Any sample code will do great ?

Regards
Rohit Arora