I wanted to create a procedure which automatically sends email to people on their birthdays.
The procedure has to be scheduled in a windows 2000 server.
I am using sql server 2000. Could anyone suggest me how to do this?
The code should not ask for any inputs during runtime.