Hi Guys,

Was going to post this in the VB.NET section but I figure its actually more of an SQL question..

Basically I have an app that needs to send reminder emails on dates selected by the user. Obviously if my app was open all the time then this wouldn't be a problem but I want to be able to ensure the emails get sent even if no one has my app open. So the first thing I thought of was just to write a vb.net windows service that sends these emails out but I'd rather not make users of my app have to install services on a server if it can be helped.
I remember that someone mentioned to me a while ago that SQL could do like scheduled task kinda things and I wondered if it would be possible for me to get the SQL database to handle the automated emails entirely (my app is aimed at SQL 2000 or higher).
Anyone got any pointers for where to start and any advice on what the best way of doing this is, if its even possible?

Thanks
Chris