Posted by stephen on 08/24/07 07:57

On Aug 24, 7:47 am, sachin shah <sachin28...@gmail.com> wrote:
> hi all
>
> my query is how can i send mail by using sql server, i think by unsing
> xp_sendmail store procedure we can do this but my problem is what
> paramater to be pass to this store procedure if i want to send mail
> from my local machine to another user, bcos i am geeting this error
> msg in query analyzer...
>
> query:-EXEC master..xp_sendmail 'ss35934' (ss35934 is valid user name
> present into my local nerwork)
>
> getting error msg :- xp_sendmail: failed with mail error 0x80040111
>
> from:- sachin shah

I had a similar problem and was advised not to use xp_sendmail. I
don't understand how sql server communicates with email. I don't know
the difference between using xp_sendmail (does not work) and sending a
notification email in the job scheduler (which does work)!

There's an alternative you could try which is available from
http://www.sqldev.net/xp/xpsmtp.htm

[Back to original message]