MAPI email service for SQL 7.0

Hello,
We recently set up our SQL 7.0 server (on Win2k) to email us on
different things (mainly results for Database Maintenance Plans). We
went through the process of installing Outlook and configuring SQL to
use its MAPI profile, etc., and it works fine. But my question is, is
there an alternative to using Outlook? I know there's Netscape and
Eudora, but an ideal solution would be a lightweight app that would
run as a service, that would send mail for its MAPI profile. Does
such a thing exist? The current setup works but is kind of
cumbersome. Sending email by SMTP would be even better, but so far we
haven't found anything that can do that, either, that interfaces with
SQL server's Maintenance Plans, etc.
Thanks for all feedback.
--
Chris> cumbersome. Sending email by SMTP would be even better, but so far we
> haven't found anything that can do that, either, that interfaces with
> SQL server's Maintenance Plans, etc.
http://www.aspfaq.com/2403
Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
interface directly with maintenance plans (how often are you modifying these
in such a way that however you set them up will change?). What I do is
manually add a step to the job, which calls xp_smtp_sendmail (among other
things), and make that the last step. Previous steps move to the last step
on error. And the last step before the sendmail step just completes on
success, and moves to the "last" step on failure.|||Forget the SQL Server built in MAPI. It stinks and has a bunch of security
holes. Plus, it's hard to configure.
If you want to simply send e-mail from SQL Server using SMTP, download this
little gem. Simply copy the .DLL to your binary directory, registry the
X_SP and you're off.
Add "smarthost" to your hosts file if you wish to have it use the default IP
from here. Otherwise, you'll have to pass it the TCP/IP of your mail
server as a parameter. This has built in SMTP Agent.
http://www.sqldev.net/xp/xpsmtp.htm
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > cumbersome. Sending email by SMTP would be even better, but so far we
> > haven't found anything that can do that, either, that interfaces with
> > SQL server's Maintenance Plans, etc.
> http://www.aspfaq.com/2403
> Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> interface directly with maintenance plans (how often are you modifying
these
> in such a way that however you set them up will change?). What I do is
> manually add a step to the job, which calls xp_smtp_sendmail (among other
> things), and make that the last step. Previous steps move to the last
step
> on error. And the last step before the sendmail step just completes on
> success, and moves to the "last" step on failure.
>|||Thanks for all of the input. I have downloaded & installed XPSMTP and
it works great. The reason I originally inquired about easy interface
with Maintenance Plans was for other uses to easily create/modify new
Maintenance plans, and set up email easily.
Thanks again,
--
Chris
"David M" <scandal123@.cox.net> wrote in message news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> Forget the SQL Server built in MAPI. It stinks and has a bunch of security
> holes. Plus, it's hard to configure.
> If you want to simply send e-mail from SQL Server using SMTP, download this
> little gem. Simply copy the .DLL to your binary directory, registry the
> X_SP and you're off.
> Add "smarthost" to your hosts file if you wish to have it use the default IP
> from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> server as a parameter. This has built in SMTP Agent.
> http://www.sqldev.net/xp/xpsmtp.htm
>
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > cumbersome. Sending email by SMTP would be even better, but so far we
> > > haven't found anything that can do that, either, that interfaces with
> > > SQL server's Maintenance Plans, etc.
> >
> > http://www.aspfaq.com/2403
> >
> > Not sure why xp_smtp_sendmail would be discarded simply because it doesn't
> > interface directly with maintenance plans (how often are you modifying
> these
> > in such a way that however you set them up will change?). What I do is
> > manually add a step to the job, which calls xp_smtp_sendmail (among other
> > things), and make that the last step. Previous steps move to the last
> step
> > on error. And the last step before the sendmail step just completes on
> > success, and moves to the "last" step on failure.
> >
> >|||Is there any concern for the stability of the xpsmtp extended proc since it
runs in the same memory space as sql server?
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||Is there any concern about the stability of this extended proc since it runs
in the same mem space as sqlserver
"Chris Szilagyi" <chris@.groupinfo.com> wrote in message
news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> Thanks for all of the input. I have downloaded & installed XPSMTP and
> it works great. The reason I originally inquired about easy interface
> with Maintenance Plans was for other uses to easily create/modify new
> Maintenance plans, and set up email easily.
> Thanks again,
> --
> Chris
> "David M" <scandal123@.cox.net> wrote in message
news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > Forget the SQL Server built in MAPI. It stinks and has a bunch of
security
> > holes. Plus, it's hard to configure.
> >
> > If you want to simply send e-mail from SQL Server using SMTP, download
this
> > little gem. Simply copy the .DLL to your binary directory, registry the
> > X_SP and you're off.
> >
> > Add "smarthost" to your hosts file if you wish to have it use the
default IP
> > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > server as a parameter. This has built in SMTP Agent.
> >
> > http://www.sqldev.net/xp/xpsmtp.htm
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > cumbersome. Sending email by SMTP would be even better, but so far
we
> > > > haven't found anything that can do that, either, that interfaces
with
> > > > SQL server's Maintenance Plans, etc.
> > >
> > > http://www.aspfaq.com/2403
> > >
> > > Not sure why xp_smtp_sendmail would be discarded simply because it
doesn't
> > > interface directly with maintenance plans (how often are you modifying
> > these
> > > in such a way that however you set them up will change?). What I do
is
> > > manually add a step to the job, which calls xp_smtp_sendmail (among
other
> > > things), and make that the last step. Previous steps move to the last
> > step
> > > on error. And the last step before the sendmail step just completes
on
> > > success, and moves to the "last" step on failure.
> > >
> > >|||I use it extensively in mission critical apps and have yet to notice any
issues whatsoever.
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since
it
> runs in the same memory space as sql server?|||> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
The same applies for xp_sendmail. It is also an extended stored procedure. Personally, I have the
greatest confidence in the developer of xp_smtp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:wsGnb.77882$W77.8168@.bignews6.bellsouth.net...
> Is there any concern for the stability of the xpsmtp extended proc since it
> runs in the same memory space as sql server?
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||It's a shame that something that seems so trivial wasn't done by Microsoft.
Something like XPSMTP originally instead of xp_sendmail would have made
things much more easier for SQL Admins--especially when only needing to send
outgoing mail from SQL Server. Who knows -- maybe Yukon will have a few
surprises...
"Rohan Balraj" <rohanbalraj@.bellsouth.net> wrote in message
news:ItGnb.77890$W77.37198@.bignews6.bellsouth.net...
> Is there any concern about the stability of this extended proc since it
runs
> in the same mem space as sqlserver
> "Chris Szilagyi" <chris@.groupinfo.com> wrote in message
> news:2aab79d7.0310281216.1ee8bc38@.posting.google.com...
> > Thanks for all of the input. I have downloaded & installed XPSMTP and
> > it works great. The reason I originally inquired about easy interface
> > with Maintenance Plans was for other uses to easily create/modify new
> > Maintenance plans, and set up email easily.
> >
> > Thanks again,
> > --
> > Chris
> >
> > "David M" <scandal123@.cox.net> wrote in message
> news:<q8mlb.200840$%h1.197478@.sccrnsc02>...
> > > Forget the SQL Server built in MAPI. It stinks and has a bunch of
> security
> > > holes. Plus, it's hard to configure.
> > >
> > > If you want to simply send e-mail from SQL Server using SMTP, download
> this
> > > little gem. Simply copy the .DLL to your binary directory, registry
the
> > > X_SP and you're off.
> > >
> > > Add "smarthost" to your hosts file if you wish to have it use the
> default IP
> > > from here. Otherwise, you'll have to pass it the TCP/IP of your mail
> > > server as a parameter. This has built in SMTP Agent.
> > >
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > >
> > >
> > >
> > > "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:uZvL2S0lDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > > > > cumbersome. Sending email by SMTP would be even better, but so
far
> we
> > > > > haven't found anything that can do that, either, that interfaces
> with
> > > > > SQL server's Maintenance Plans, etc.
> > > >
> > > > http://www.aspfaq.com/2403
> > > >
> > > > Not sure why xp_smtp_sendmail would be discarded simply because it
> doesn't
> > > > interface directly with maintenance plans (how often are you
modifying
> > > these
> > > > in such a way that however you set them up will change?). What I do
> is
> > > > manually add a step to the job, which calls xp_smtp_sendmail (among
> other
> > > > things), and make that the last step. Previous steps move to the
last
> > > step
> > > > on error. And the last step before the sendmail step just completes
> on
> > > > success, and moves to the "last" step on failure.
> > > >
> > > >
>|||> Who knows -- maybe Yukon will have a few surprises...
There has been a bit of rumbling about (and definitely a lot of screaming
and begging for) a new e-mail system, but it's way too early to tell if it
will be implemented at all, and if so, whether it will make it into Yukon,
or Yukon + 1, or Yukon + n... never mind what it will look like, and whether
it will support SMTP and POP3, or just SMTP, etc. As you said, maybe there
will be a few surprises... we'll have to wait for subsequent bits, I
suppose. :-)