I am using SQL Server v8. In my web application and in the following scenario, is my solution possible? If so, how would I do it?
A user wants to be notified 2 days before their membership expires. I am gathering that I could fire a trigger at 1:00 am to search the DB, retrieve the users emails from the DB, and send an email through the DB. I am assuming that SQL Server could fire the trigger at 1:00, run the query, and send a email. Is this possible in SQL Server?
I know the email part is possible in Oracle and I believe that Oracle can also fire a trigger at a certain time as well, but is it possible in SQL Server? Is so, how?
I am not a DB wizard by any means, so have your answers fairly descriptive.