> 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, CDONTS or something (that last part i don't know much about, as i don't do network interfaces) but the database part of your setup is quite feasible with sql2000 rudy ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]