Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
Showing posts with label xp_sendmail. Show all posts
Showing posts with label xp_sendmail. Show all posts
Tuesday, March 27, 2012
emails reside in Inbox?
Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
jouj
Hi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/default...b;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
Monday, March 26, 2012
emails reside in Inbox?
Hi,
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
I'm working on MS SqL 2K
and I have installed MS Outlook.
I've configured the SQL Mail and SQL Agent Mail.
when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
and are not sent to the right recipients, so I should re-send them from
Outlook.
I'm missing something for sure, what is it?
thanks in advance.
joujHi
Your emails should be sent, but at a guess your are using Outlook 2002 or
later in which case it has to be running on the server see
http://support.microsoft.com/defaul...kb;en-us;263556
The easiest solution is to install Outlook 2000 or use xpsmtp
http://www.sqldev.net/xp/xpsmtp.htm
John
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:89B5CE19-71C3-41B4-B846-9CF844AAF58A@.microsoft.com...
> Hi,
> I'm working on MS SqL 2K
> and I have installed MS Outlook.
> I've configured the SQL Mail and SQL Agent Mail.
> when I use the xp_sendmail, the emails reside in the Inbox of the Outlook
> and are not sent to the right recipients, so I should re-send them from
> Outlook.
> I'm missing something for sure, what is it?
> thanks in advance.
> jouj
>
Monday, March 19, 2012
Email Notifications
Hi All,
I have a sql2k running on w2k adv. svr and have a stored procedure which
sends email notifications to clients using xp_sendmail.
Out of the 25 email notifications 1 or 2 fails every other day which is
unacceptable to my clients.
Checking all my logs, I see that the xp_sendmail query runs successfully all
the time.
I need to understand why the query runs successfully all the time and yet
get 1 or 2 email failures?
ThanksIt can a problem with the mail system. Since SQL Server using MAPI to send a
mail, you should check your mail transport.
There are a lot of issues can happen during mail delivery. First of all try
to check is there everything is Ok with
your MS Outlook during the failure time. Then you can check MS Exchange
Server logs if you are using it.
It also can be network issue.
Regards
---
All information provided above AS IS.
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a sql2k running on w2k adv. svr and have a stored procedure which
> sends email notifications to clients using xp_sendmail.
> Out of the 25 email notifications 1 or 2 fails every other day which is
> unacceptable to my clients.
> Checking all my logs, I see that the xp_sendmail query runs successfully
all
> the time.
> I need to understand why the query runs successfully all the time and yet
> get 1 or 2 email failures?
> Thanks
>|||Thanks Sky,
I also forgot to add the error generated by sql, it might help.
The message below is generated anytime the email fails.
Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> It can a problem with the mail system. Since SQL Server using MAPI to send
a
> mail, you should check your mail transport.
> There are a lot of issues can happen during mail delivery. First of all
try
> to check is there everything is Ok with
> your MS Outlook during the failure time. Then you can check MS Exchange
> Server logs if you are using it.
> It also can be network issue.
>
> Regards
> ---
> All information provided above AS IS.
>
> "caddo65590" <caddo65590@.hotmail.com> wrote in message
> news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> > I have a sql2k running on w2k adv. svr and have a stored procedure which
> > sends email notifications to clients using xp_sendmail.
> > Out of the 25 email notifications 1 or 2 fails every other day which is
> > unacceptable to my clients.
> > Checking all my logs, I see that the xp_sendmail query runs successfully
> all
> > the time.
> > I need to understand why the query runs successfully all the time and
yet
> > get 1 or 2 email failures?
> > Thanks
> >
> >
>|||Did you search KB for that return code. I found at least two articles for
that return code that referred to xp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:OKuLYdKpDHA.2776@.tk2msftngp13.phx.gbl...
> Thanks Sky,
> I also forgot to add the error generated by sql, it might help.
> The message below is generated anytime the email fails.
> Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
> "SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
> news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> > It can a problem with the mail system. Since SQL Server using MAPI to
send
> a
> > mail, you should check your mail transport.
> > There are a lot of issues can happen during mail delivery. First of all
> try
> > to check is there everything is Ok with
> > your MS Outlook during the failure time. Then you can check MS Exchange
> > Server logs if you are using it.
> > It also can be network issue.
> >
> >
> >
> > Regards
> > ---
> > All information provided above AS IS.
> >
> >
> > "caddo65590" <caddo65590@.hotmail.com> wrote in message
> > news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > > I have a sql2k running on w2k adv. svr and have a stored procedure
which
> > > sends email notifications to clients using xp_sendmail.
> > > Out of the 25 email notifications 1 or 2 fails every other day which
is
> > > unacceptable to my clients.
> > > Checking all my logs, I see that the xp_sendmail query runs
successfully
> > all
> > > the time.
> > > I need to understand why the query runs successfully all the time and
> yet
> > > get 1 or 2 email failures?
> > > Thanks
> > >
> > >
> >
> >
>
I have a sql2k running on w2k adv. svr and have a stored procedure which
sends email notifications to clients using xp_sendmail.
Out of the 25 email notifications 1 or 2 fails every other day which is
unacceptable to my clients.
Checking all my logs, I see that the xp_sendmail query runs successfully all
the time.
I need to understand why the query runs successfully all the time and yet
get 1 or 2 email failures?
ThanksIt can a problem with the mail system. Since SQL Server using MAPI to send a
mail, you should check your mail transport.
There are a lot of issues can happen during mail delivery. First of all try
to check is there everything is Ok with
your MS Outlook during the failure time. Then you can check MS Exchange
Server logs if you are using it.
It also can be network issue.
Regards
---
All information provided above AS IS.
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a sql2k running on w2k adv. svr and have a stored procedure which
> sends email notifications to clients using xp_sendmail.
> Out of the 25 email notifications 1 or 2 fails every other day which is
> unacceptable to my clients.
> Checking all my logs, I see that the xp_sendmail query runs successfully
all
> the time.
> I need to understand why the query runs successfully all the time and yet
> get 1 or 2 email failures?
> Thanks
>|||Thanks Sky,
I also forgot to add the error generated by sql, it might help.
The message below is generated anytime the email fails.
Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> It can a problem with the mail system. Since SQL Server using MAPI to send
a
> mail, you should check your mail transport.
> There are a lot of issues can happen during mail delivery. First of all
try
> to check is there everything is Ok with
> your MS Outlook during the failure time. Then you can check MS Exchange
> Server logs if you are using it.
> It also can be network issue.
>
> Regards
> ---
> All information provided above AS IS.
>
> "caddo65590" <caddo65590@.hotmail.com> wrote in message
> news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> > I have a sql2k running on w2k adv. svr and have a stored procedure which
> > sends email notifications to clients using xp_sendmail.
> > Out of the 25 email notifications 1 or 2 fails every other day which is
> > unacceptable to my clients.
> > Checking all my logs, I see that the xp_sendmail query runs successfully
> all
> > the time.
> > I need to understand why the query runs successfully all the time and
yet
> > get 1 or 2 email failures?
> > Thanks
> >
> >
>|||Did you search KB for that return code. I found at least two articles for
that return code that referred to xp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:OKuLYdKpDHA.2776@.tk2msftngp13.phx.gbl...
> Thanks Sky,
> I also forgot to add the error generated by sql, it might help.
> The message below is generated anytime the email fails.
> Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
> "SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
> news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> > It can a problem with the mail system. Since SQL Server using MAPI to
send
> a
> > mail, you should check your mail transport.
> > There are a lot of issues can happen during mail delivery. First of all
> try
> > to check is there everything is Ok with
> > your MS Outlook during the failure time. Then you can check MS Exchange
> > Server logs if you are using it.
> > It also can be network issue.
> >
> >
> >
> > Regards
> > ---
> > All information provided above AS IS.
> >
> >
> > "caddo65590" <caddo65590@.hotmail.com> wrote in message
> > news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > > I have a sql2k running on w2k adv. svr and have a stored procedure
which
> > > sends email notifications to clients using xp_sendmail.
> > > Out of the 25 email notifications 1 or 2 fails every other day which
is
> > > unacceptable to my clients.
> > > Checking all my logs, I see that the xp_sendmail query runs
successfully
> > all
> > > the time.
> > > I need to understand why the query runs successfully all the time and
> yet
> > > get 1 or 2 email failures?
> > > Thanks
> > >
> > >
> >
> >
>
Email in SQL 2005 - Invalid parameter '@ansi_attachment'
Hello, I'm using xp_sendmail in SQL 2005 and received this error
"xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
@.ansi_attachment no longer supported in 2005
Sample Below
Select @.SQLQuery = 'Declare @.rc int
EXEC @.rc = master.dbo.xp_sendmail
@.recipients = N'''+@.vTo+'''
,@.message = N'''+@.vMessage+'''
,@.query = N'''+@.vSQL+'''
,@.attachments =''Prices Expiring.txt''
,@.ansi_attachment=''TRUE''
,@.copy_recipients = N'''+@.vCC+'''
,@.subject = N'''+@.vSubject+'''
,@.attach_results = ''TRUE''
,@.width = 500I see this article but, since I do not see any mention of the parameter in
either 2000 or 2005 Books Online, I imagine this was only a temporary fix.
Is there any reason you would ever want to set the value to false? If not,
then my suggestion is to check the registry value (I can't imagine it would
default to false). Support will probably steer you towards database mail in
2005, as opposed to SQL Mail, anyway...
A
"Don" <Don@.discussions.microsoft.com> wrote in message
news:6362A1E7-524F-46C3-912D-ABBCCCA5A6DB@.microsoft.com...
> Hello, I'm using xp_sendmail in SQL 2005 and received this error
> "xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
> @.ansi_attachment no longer supported in 2005
> Sample Below
> Select @.SQLQuery = 'Declare @.rc int
> EXEC @.rc = master.dbo.xp_sendmail
> @.recipients = N'''+@.vTo+'''
> ,@.message = N'''+@.vMessage+'''
> ,@.query = N'''+@.vSQL+'''
> ,@.attachments =''Prices Expiring.txt''
> ,@.ansi_attachment=''TRUE''
> ,@.copy_recipients = N'''+@.vCC+'''
> ,@.subject = N'''+@.vSubject+'''
> ,@.attach_results = ''TRUE''
> ,@.width = 500
>
>
"xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
@.ansi_attachment no longer supported in 2005
Sample Below
Select @.SQLQuery = 'Declare @.rc int
EXEC @.rc = master.dbo.xp_sendmail
@.recipients = N'''+@.vTo+'''
,@.message = N'''+@.vMessage+'''
,@.query = N'''+@.vSQL+'''
,@.attachments =''Prices Expiring.txt''
,@.ansi_attachment=''TRUE''
,@.copy_recipients = N'''+@.vCC+'''
,@.subject = N'''+@.vSubject+'''
,@.attach_results = ''TRUE''
,@.width = 500I see this article but, since I do not see any mention of the parameter in
either 2000 or 2005 Books Online, I imagine this was only a temporary fix.
Is there any reason you would ever want to set the value to false? If not,
then my suggestion is to check the registry value (I can't imagine it would
default to false). Support will probably steer you towards database mail in
2005, as opposed to SQL Mail, anyway...
A
"Don" <Don@.discussions.microsoft.com> wrote in message
news:6362A1E7-524F-46C3-912D-ABBCCCA5A6DB@.microsoft.com...
> Hello, I'm using xp_sendmail in SQL 2005 and received this error
> "xp_sendmail: Invalid parameter '@.ansi_attachment'" ; is this
> @.ansi_attachment no longer supported in 2005
> Sample Below
> Select @.SQLQuery = 'Declare @.rc int
> EXEC @.rc = master.dbo.xp_sendmail
> @.recipients = N'''+@.vTo+'''
> ,@.message = N'''+@.vMessage+'''
> ,@.query = N'''+@.vSQL+'''
> ,@.attachments =''Prices Expiring.txt''
> ,@.ansi_attachment=''TRUE''
> ,@.copy_recipients = N'''+@.vCC+'''
> ,@.subject = N'''+@.vSubject+'''
> ,@.attach_results = ''TRUE''
> ,@.width = 500
>
>
Subscribe to:
Posts (Atom)