Rudy,
I know that the prepacked sp_send_cdosysmail will do the job of sending
email. that part is fine and I can send mail till the cows come home
What is giving me fits is getting the horse outta of the gate. I initially
did this as an ASP page. But my boss wanted to raise the challenge
Can this be performed in MSSQL2k
yes, everything up to the send email part
you need a script (ASP?) or scheduled task to call the database, exec the
stored proc, handle the query results, decide who gets email, and then hand
the email over to some other windows network task, or server,