xp_sendmail Error 18009

[Patrick Wright]

SQL server agent and SQL both log on as the same user and use the same mail profile. SQL server agent sends mail beautifully. I can view the properties of the SQL Server Agent and SQL mail.

When I execute xp_sendmail it does not send a mail message. When I go to view the properties of SQL Mail or SQL Server Agent the Enterprise Manager locks up.

The application logs shows an error# 18009 with a severity of 18.

I reboot the machine and all is well. I still cannot use xp_sendmail

Help.

[Patrick]

Try using internet names to send the mail instead of the outlook/exchange names. Example

exec master.dbo.xpsendmail 'Fred@internet.com','Subject',&#39 ;Message'


------------
Patrick Wright at 10/29/99 10:19:38 AM

SQL server agent and SQL both log on as the same user and use the same mail profile. SQL server agent sends mail beautifully. I can view the properties of the SQL Server Agent and SQL mail.

When I execute xp_sendmail it does not send a mail message. When I go to view the properties of SQL Mail or SQL Server Agent the Enterprise Manager locks up.

The application logs shows an error# 18009 with a severity of 18.

I reboot the machine and all is well. I still cannot use xp_sendmail

Help.