I want to be able to use SQLMail to send me alerts on
task failures, etc. Microsoft says we have to use a MAPI
client like MS Outlook to take advantage of this feature.
However, when I talk with my system administrators about
placing Outlook or similar mail clients on the server
they get all upset and scream about security. Are there
alternatives to Outlook that are more secure or less
intrusive or anything that would make the sa's happy and
still be able to use SQLMail?
You can use xp_smtp_sendmail from www.sqldev.net
It isn't nearly as integrated as SQL Mail, but by adding a few steps to your
SQL Agent jobs, you can get most of the same functionality. It is very
stable and does exactly what the documentation says it does.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security. Are there
> alternatives to Outlook that are more secure or less
> intrusive or anything that would make the sa's happy and
> still be able to use SQLMail?
|||"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security.
do you blame them ? installing Outlook on a database server is nuts ...
|||http://www.aspfaq.com/2403
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security. Are there
> alternatives to Outlook that are more secure or less
> intrusive or anything that would make the sa's happy and
> still be able to use SQLMail?
|||"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> http://www.aspfaq.com/2403
Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ; what
client do you recommend ? Thanks ...
|||Should work in pretty much any, I don't have a personal preference...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Liz" <liz@.tiredofspam.com> wrote in message
news:eIpSqv3NEHA.3016@.tk2msftngp13.phx.gbl...
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment