|
|
Posted by Dan Guzman on 08/24/07 12:06
> but after executing these query getting the following error msg..
>
> Error: connecting to server smarthost
'smarthost' is the default name of the SMTP server. It is very likely that
your actual SMTP server is named something else so you'll need to specify
the name using the @server parameter:
DECLARE @rc int
EXEC @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@TO = N'MyFriend@HisDomain.com',
@server =N'MY-SMTP-SERVER'
SELECT RC = @rc
See the xpxmtp documentation for detailed usage:
http://www.sqldev.net/xp/xpsmtp.htm
--
Hope this helps.
Dan Guzman
SQL Server MVP
"sachin shah" <sachin28880@gmail.com> wrote in message
news:1187943974.754692.292770@r23g2000prd.googlegroups.com...
> 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]
|