SQL Mail sending multiple copies of the same message

[livezone]

I am using Master..xp_sendMail to send email to user when a new record is inserted into the sql table. But Sometime multiple copies have been sent for the same email. Is this problem related to SQL Mail or Exchange Server?

Kindly Guide
Thanks
Shafiq

 

[vongrunt]

How are you calling xp_sendMail()? From trigger on sql table?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[livezone]

Yes, From Trigger on the table, I should only get 1 row from the inserted table as I am using the following statements

Select @OrderID=OrderID from inserted

It was working since last 2 years

 

[mrdenny]

This is just another reason that I recommend not using xp_sendmail directly from triggers. I always recommend logging the data into a table, then having a job send the emails. This way you get a nice record you can look at to see if this is a SQL problem, or an Exchange problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)