i have a nightly scheduled task that is spec'd to send an email. in other environments, i have used SQL Server's xp_sendmail to generate and send email w/ attachments.
i have opened a ticket asking that xp_sendmail be given access from my db login or for smarthost to be defined for...
Tonto:
What did you use for your @server parameter?
For mssql5, my smarthost isn't defined and xp_smtp_sendmail lacks the authentication means to use my normal mail.mysite.com as an outgoing mail server.