sqlmail

difference xp_sendmail and sp_send_dbmail proc..

Hi all!! Can I ask what is the difference between xp_sendmail and sp_send_dbmail proc? They are both send e-mail message, which may include a query result set attachment, to the specified recipients..... What is the difference? ...

Create Insert Trigger for SQLAgentMail

Is it possible to create a trigger the will use SQLAgentMail and email an operator? ...