Hello,
I am wondering, what is the correct way to send mail from SQL Server 2005?
For example, we have an older 2000 job that used to run every 5 or 10 minutes or so, which called a stored procedure that read a table in the database and used xp_smtp_SendMail to send the mail.
This job has never run propery in 2005, and remains broken.
Is this just a simple matter of replacing the xp_smtp_SendMail with a similar 2005 version?
Or does this require something new and different?
BOL recommends using "Database Mail" instead of xp_smtp_SendMail... but there's also other stored procedures, such as "sp_send_dbmail", so I'm
confused.
Any clarification appreciated.
Thanks much
I am wondering, what is the correct way to send mail from SQL Server 2005?
For example, we have an older 2000 job that used to run every 5 or 10 minutes or so, which called a stored procedure that read a table in the database and used xp_smtp_SendMail to send the mail.
This job has never run propery in 2005, and remains broken.
Is this just a simple matter of replacing the xp_smtp_SendMail with a similar 2005 version?
Or does this require something new and different?
BOL recommends using "Database Mail" instead of xp_smtp_SendMail... but there's also other stored procedures, such as "sp_send_dbmail", so I'm
confused.
Any clarification appreciated.
Thanks much