Hi Aish,

There are several questions you would need to consider and answer before anyone can really help you get going in the right direction....

1) How do you want to be notified... e-mail? pop-up window? Text mail to your phone?

2) How do you want this triggered? In other words, Do you want the date check to run at 12AM every day? Or would you rather it only run when you log on to your workstation?

3) What machine is going to trigger it... the SQL server or your workstation? (Or do you have only one machine that is always on?) If you run it on the server, what do you want it to do with your notification if your workstation is not online (not an issue if you are emailing the notice)?

There are two sides of this see-saw:

If you run it on the server, triggering the event is easy, but sending the notice out gets a bit more complicated, whether using SQLMail or coding your own CDO or CDONTS (or other object) script .....

If you run it on your local workstation, especially in your login or startup script, then triggering the check and posting the notice is very easy, but getting the information from the database becomes the more difficult part requiring ODBC connections and some local scripting.

The prefered method would be to have the server trigger it at a specified time each day, and send an email to a email address that you can change as necessary.

If you can answer the above questions, I'll see how much more I can help.

:mrgreen:

Elohir