Loading

Mail Triggering in SQL-Server2005

SABAREES RAJA

18y3k

hi friends,

I need to trigger a mail when i update data from a particular table. I got a Procedure for mailing, it executed successfully. but, when i update the data from a table, below error was Accured.

xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

how can i solve this problem? can anybody faced this before, give me a reply.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Hi

Log on to the Server using the same account that the SQL Server Agent service uses to connect. Configure the mailbox for this account in the control pannel. Run MS Outlook and set it as the default mail client if it asks. Log out and try xp_sendmail again.

Thanks -- Vj

http://dotnetvj.blogspot.com
Bechir Bejaoui18y ago
I had the same problem like you until i used the ansmtp witch enables you send mail without having the necessity to be suscribed in mail service browse to this and download ansmtp