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?
views:
128answers:
1
+3
A:
xp_sendmail requires a MAPI client installed, such as Outlook, on the server. This is the only option for SQL Server 2000 and before.
sp_send_dbmail is a simple SMTP solution, added for SQL Server 2005+
sp_send_dbmail is by far better.
gbn
2009-08-01 13:21:40
Thanks.... I understand!!
2009-08-01 13:30:22
Please click the big tick on the left to accept he answer if you like it :-)
gbn
2009-08-01 13:31:13