hi friends...
i had a problem with sending mail using trigger when Update data from a table. Procedure is executed successfully. but when i update record from a particular table. I had a following error
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.
(0 row(s) affected)
Can any one explain what's my problem and give me a solution for this.
it's Urgent !!!!!!!
SABAREES RAJAPosted Jun 14, 2008, 5:20 PM
This is my query. if you know what's my mistake, kindly correct it. thanks in advance!!!!
CREATE TRIGGER employeeUpdateMail
ON employee
FOR UPDATE
AS
declare @body varchar(2000)
SET @body = 'Customer with ID=100 has been updated,getdate()'
EXEC master..xp_sendmail
@recipients = '[email protected]',
@subject = 'Customer Information Updated',
@message = @body
GO
Bechir BejaouiPosted Jun 14, 2008, 5:04 PM