'master..xp_smtp_SendMail'.

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 youxp_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, tootsuite@.gmail.com wrote:

>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|||<DIV><tootsuite@.gmail.com> wrote in message
news:1157577557.082293.219110@.m73g2000cwd.googlegroups.com...</DIV>> 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
>
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 wor
k.
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
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"tootsuite@.gmail.com" wrote:

> 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
>|||tootsuite@.gmail.com wrote:
> 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
>
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.
Tracy McKibben
MCDBA
http://www.realsqlguy.com