A snippet from
http://support.microsoft.com/defaul...kb;en-us;263556
says:
How To Set Up SQL Mail With An Internet Mail Server
WARNING: Unless you can guarantee 100% connectivity to your Internet mail
server without the need to reauthenticate your mail logon, SQL Mail can
hang, forcing you to stop and restart SQL Server. Use of an Internet mail
server is not a recommended solution but may be the only alternative in some
cases.
The procedure for setting up SQL Mail with an Internet mail server
(POP3/SMTP server) is similar to that for setting up SQL Mail with an
Exchange Server:
I was wondering if anyone has experienced similar downfalls to using
xp_smtp_sendmail if the SMTP box is unavailable for a while?
TIA, ChrisR> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
Nope.
Keith
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/defaul...kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>|||The problem with sp_sendmail has to do with using Outlook as a Service.
Outlook will try and pop up a dialog box. Since there is normally no UI,
this fails and hangs the MAPI session. The only way to recover is to drop
both ends of the MAPI session with a SQL server restart.
Xp_smtp_sendmail simply times out and returns an error code to the procedure
caller.
In short, the same problem does not and cannot occur. This is the number
one reason I use xp_smtp_sendmail.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/defaul...kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>|||Another way to use CDO: CDO.Message
with sp_OA...
If you want I can post example.
Regards,
SkyWalker.
"ChrisR" wrote:
> A snippet from
> http://support.microsoft.com/defaul...kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in so
me
> cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>
>|||Im good now, thanks.
"SkyWalker" <SkyWalker@.discussions.microsoft.com> wrote in message
news:1B4578C6-776D-4D26-9B1C-1D3DD9629CC1@.microsoft.com...[vbcol=seagreen]
> Another way to use CDO: CDO.Message
> with sp_OA...
> If you want I can post example.
> Regards,
> SkyWalker.
> "ChrisR" wrote:
>|||Thanks to all, Im alot more comfortable with this now.
ChrisR
"ChrisR" <noemail@.bla.com> wrote in message
news:O%23iSi$VYFHA.4036@.tk2msftngp13.phx.gbl...
>A snippet from
>http://support.microsoft.com/defaul...kb;en-us;263556
> says:
> How To Set Up SQL Mail With An Internet Mail Server
> WARNING: Unless you can guarantee 100% connectivity to your Internet mail
> server without the need to reauthenticate your mail logon, SQL Mail can
> hang, forcing you to stop and restart SQL Server. Use of an Internet mail
> server is not a recommended solution but may be the only alternative in
> some cases.
> The procedure for setting up SQL Mail with an Internet mail server
> (POP3/SMTP server) is similar to that for setting up SQL Mail with an
> Exchange Server:
>
> I was wondering if anyone has experienced similar downfalls to using
> xp_smtp_sendmail if the SMTP box is unavailable for a while?
>
> TIA, ChrisR
>
>
Tuesday, March 20, 2012
another xp_smtp_sendmail question
Labels:
database,
defaul,
fromhttp,
internet,
kben-us263556sayshow,
mail,
microsoft,
mysql,
oracle,
server,
serverwarning,
snippet,
sql,
unless,
xp_smtp_sendmail
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment