Post reply

Sending mail from SQL Server

  • November 27, 2004 at 3:49 am

    #182958

    Hy,

    I am a junior DBA on SQL Server 2000. I administrate many servers, and I want to send mail with statistics from applications as a response of the jobs I run.

    First a wanted to use SQLMail, but the network administrator sad it is unsecure. Then I tried to use extended stored procedures, sp_OACreate("CDO.Message"). It works, but I received again the response that the use of these extended stored procedures is unsafe  .

    I searched on the net, it was indeed a problem with them before SP1 (buffer overflow), but all my servers are 8.00.818 version.

    How secure is sending mail from sql server 2000? Are my solutions wrong ? Can you give me another?

    Thanks, LiviuB

  • November 27, 2004 at 12:49 pm

    #531651

    Take a look at the extended procdure xp_smtp_sendmail from http://www.sqldev.net/xp/xpsmtp.htm.  It's easy to use and easy to install, and both safe and secure.  I use it on both production and development servers and have never had any problems.  If you look at the sql server newsgroups you will find that this procedure is highly recommended and highly used, from SQL Server MVPs on down.

    Gert Drapers, the author of the extended proc, is a Program Manager for SQL Server Development and has been an architect for SQL Server Tools.

    That gives its background.  Of course, you should test it in your particular environment.  I think, though, that you will find it works great.

     

    Scott Thornburg

    Volt Information Sciences

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply