|
|
Posted by sachin shah on 08/24/07 08:26
On Aug 24, 12:57 pm, stephen <m0604...@googlemail.com> wrote:
> 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 fromhttp://www.sqldev.net/xp/xpsmtp.htm
hi stephen,
i tried with xp_smtp_sendmail but still getting the error ....
as given into site i register the xp_smtp_sendmail store procedure and
the assign the grant permission to that store procedure then writing
the following query
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com'
select RC = @rc
go
in place of this 'MyEmail@MyDomain.com' i am writing the real mail id
(first one)
in place of this 'MyFriend@HisDomain.com' i am writing the real mail
id (second one)
but after executing these query getting the following error msg..
Error: connecting to server smarthost
can u plz tell me is there any sql server id we need to right into
above query (like admin@sqlserver.com)
from sachin shah
Navigation:
[Reply to this message]
|