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...