|
|
Posted by sachin shah on 08/29/07 05:34
On Aug 24, 5:06 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
> > 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'MyEm...@MyDomain.com',
> @TO = N'MyFri...@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" <sachin28...@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'MyEm...@MyDomain.com',
> > @TO = N'MyFri...@HisDomain.com'
> > select RC = @rc
> > go
>
> > in place of this 'MyEm...@MyDomain.com' i am writing the real mail id
> > (first one)
> > in place of this 'MyFri...@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 ad...@sqlserver.com)
>
> > from sachin shah- Hide quoted text -
>
> - Show quoted text -
hi
as per u r guide line i insatalled that xp_smtp_sendmail store
procedure and assign the grant permission to that SP but after
executing the following query its showing following error....
declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'MyEmail@MyDomain.com',
@FROM_NAME = N'My Full Name',
@replyto = N'sashah@systime.net',
@TO = N'sachin28880@gmail.com',
@priority = N'NORMAL',
@subject = N'Hello SQL Server SMTP Mail',
@type = N'text/plain',
@message = N'Goodbye MAPI, goodbye Outlook',
@timeout = 10000,
@server = N'mail.sqldev.net'
select RC = @rc
go
Error Dispalyed:-
Error: sending message
Server response: 451 Local Error
put; end with <CRLF>.<CRLF>
give me the proper solution
(Note :- What is this MAPI and by where it is references in sql
server )
[Back to original message]
|