dbTalk Databases Forums  

xp_smtp_sendmail

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss xp_smtp_sendmail in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ray5531
 
Posts: n/a

Default xp_smtp_sendmail - 05-02-2005 , 11:41 AM






I'd like to use xp_smtp_sendmail in my DTS package to send an email to the
admin and also bunch of stored procedures I have.The problem is that My
database server is behind the firewall and what I read about this guy is
that it opens up a TCP/IP socket to the SMTP SERVER.Apparently I cannot use
this in my case.Is there another alternative to this.I don't want to install
SMTP server on the database server.

Thanks



Reply With Quote
  #2  
Old   
Gert E.R. Drapers
 
Posts: n/a

Default Re: xp_smtp_sendmail - 05-02-2005 , 06:43 PM






See answers in the "SMTP in my database server" thread.

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"Ray5531" <RayAll (AT) microsft (DOT) com> wrote

Quote:
I'd like to use xp_smtp_sendmail in my DTS package to send an email to
the admin and also bunch of stored procedures I have.The problem is that
My database server is behind the firewall and what I read about this guy
is that it opens up a TCP/IP socket to the SMTP SERVER.Apparently I cannot
use this in my case.Is there another alternative to this.I don't want to
install SMTP server on the database server.

Thanks




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.