I am trying to use xp_SendMail to send a mail with a query and attach results=true and I am getting "xp_sendmail: failed with operating system error 80".
I can send an email using xp_sendmail with attachment (@attachments option) but if I use query and attach results=true it will come up with xp_sendmail: failed with operating system error 80 error message.
This used to work before.
my os win2000 server+sql 2000(sp4)