• This is written for, and tested on SQL 2000 I'm afraid. I do not have 2005 so I can't help you there. I assume the xp_sendmail parameters have changed.

    Or another thought, out of the box in SQL 2005 is xp_sendmail disabled? If so, have you enabled it?

    HTH

    Dave J


    http://glossopian.co.uk/
    "I don't know what I don't know."