• mtassin (3/9/2010)


    Why not just use something like CDO or if your server is old enough CDONTS?

    Basically brings Database Mail to SQL server 2000. Just for fun I was creating sp_send_dbmail stored procs on my SQL 2000 servers that used CDO to send SMTP email out. Worked great and didn't depend on linked servers 🙂

    I won't claim to have written it... I did modify it a bit, but I can't remember where. 🙂

    [/code]

    Thanks mtassin, would try this as well

    M&M