Hi,

What is the SQL Server 2005 version of:

'master..xp_smtp_SendMail'.

Apparently, this sp does not exist in 2005 - and causes our job to
fail.

Thank you

xp_smtp_sendmail is from a third party provider (kind of) at
http://www.sqldev.net/xp/xpsmtp.htm 
So no...you won't find that extended stored procedure built
into SQL Server 2005. The closest thing in 2005 is using DB
Mail and using sp_send_dbmail.

-Sue

On 6 Sep 2006 14:19:17 -0700, tootsu***@gmail.com wrote:

Show quoteHide quote

<DIV>&lt;tootsu***@gmail.com&gt; wrote in message
Database Mail
http://msdn2.microsoft.com/en-us/library/ms175887.aspx

sp_send_dbmail
http://msdn2.microsoft.com/en-us/library/ms190307.aspx

David

If you want to use master..xp_smtp_SendMail in SQL 2005, you'll have to
recreate it from scratch as this is a custom built sp by someone on
SQLDev.Net.  You can use the 2000 .dlls (I did it myself) but you'll have to
save them in C:\Program Files\Microsoft SQL Server\90\DTS\Binn for it to work.

Big note here.  If you switch from this to DBMail, read the instructions for
DBMail VERY CAREFULLY.  You'll have to make changes to the variable names. 
I.E., instead of @TO, DBMail uses @Recipients.  If you don't change
everything over, your job will still fail.

Hope this helps.

Catadmin
Show quoteHide quote

tootsu***@gmail.com wrote:
That is a third-party utility that allows SQL 2000 to send mail through
an SMTP server.  It's no longer needed in SQL 2005, as the built-in
DBMail capability can do the same thing.  Be sure to read the
documentation on DBMail.

Backup Plan
Logging an Error During a Transaction
Maintenance Plans in SQL 2000 vs 2005
Processors
How to do sizing on Memory requirement of SQL Server 2000 ?
different file size
Sql Server 2005 Enterprise Edition(Sql server community Help required0
object owner dbo - need help
compare two columns for each row of resultset
Differential backups failing regularly