I basically need to send emails from MY DTS packages and also some of my
stored procedures.There is no way of having any MAPI compliant software
installed on the productions database server,so I came up with the idea of
installing an SMTP server and use the extended stored procedure introduced
here(http://www.sqldev.net/xp/xpsmtp.htm). Now my database admin is nagging
that I don't like to have something running in the SQL SERVER address space
and my network admin is nagging that he dosen't want to have SMTP server
installed on the production,because Microsoft dosen't recommand this. I just
wondered whay you guys have ever done in terms of sending emails from your
sql server.Is there a way of sending emails from sql server using another
SMTP server on another box(same domain thought)?

Yes of course. SMTP service need not be installed on the SQL Server. In my
case, I have different mailing server, with SMTP on it. And I specify the
SMTP server name as a parameter to the xp_smtp_sendmail stored procedure.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


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

Is there a firewall between your sql server and your mailing servers ? If
yes how come xp_smtp_sendmail opens up a TCP/IP socket to the mailing
server? In my case there is a firewall between my database serevr and also
external SMTP servers...

Thanks for your help,I'm so stuck to this problem.

Bye
"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote

The equivalent to XPSMTP is available for DTS 2000 as a DTS Custom Task,
see:
http://sqldev.net/dts/SMTPTask.htm

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

You would have to open port 25 (or if you use an other port which ever you
are using) for traffic from SQL to the SMTP server. You can also look at an
SMTP relay server solution.

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" <Ray5531 (AT) microsoft (DOT) com> wrote

Is that relay server for free?
Where should I get it from?

Thanks fro your reply.

"Gert E.R. Drapers" <GertD@SQLDevNet> wrote

There are free relay server, see
http://www.google.com/search?sourcei...P+relay+server

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

Thanks Gert,
It really helped.


"Gert E.R. Drapers" <GertD@SQLDevNet> wrote

One thing about the SMTPTask is that it expires as of June 2005. It is
mentioned at the very bottom of page. I don't know if that means it stops
working, or what.

"Gert E.R. Drapers" wrote:

Here is a script that can be added to DTS to send mail. It is what the below EXE is made out of but with a COM wrapper.

Stay tuned and I will build a COM wrapper for it or you can use it as is. You can easily modify it to meet our needs in DTS. CDO is installed on all Windows systems from 2000 on.


function SendMail(strTo, strFrom, strSubject,strText,strSMTPServer) 'As Boolean
On Error Resume Next
SendMail = True
Set objEmail = CreateObject("CDO.Message")
If Err = 0 Then
objEmail.From = strFrom
objEmail.To = strTo
objEmail.Subject = strSubject
objEmail.Textbody = strText
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTPServer
objEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objEmail.Configuration.Fields.Update
objEmail.Send
If Err <> 0 Then
SendMail = False
End If
End If
End Function

--
Jim Vierra

"Perry Provost" <Perry Provost (AT) discussions (DOT) microsoft.com> wrote