SQL Mail setup steps needed for SQL 2000

• Gajendra-1020535

  SSC Rookie

  Points: 30

  More actions

  November 10, 2009 at 3:03 am

  #227812

  Hi,

  I need to setup a email settings on a SQL 2000 server. I need the necessary steps required to setup a SQL Mail on SQL 2000 and notifications.

  Thanks in advance ..

  --SGV.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  November 10, 2009 at 2:37 pm

  #1077544

  http://msdn.microsoft.com/en-us/library/aa213788(SQL.80).aspx

  http://support.microsoft.com/kb/263556

  For SQL Mail to work though, you will need a MAPI client on the server sending the mail. If you cannot go to Database Mail with SQL 2005 I would recommend having a job step that runs a VBScript that can send a mail notification to you. All you really need is a mail relay to send the mail through.

  http://www.paulsadowski.com/WSH/cdo.htm

  Joie Andrew
  "Since 1982"

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  November 10, 2009 at 3:00 pm

  #1077555

  Here is what I used to use on my SQL 2000 servers. Works great and there is no need to install any additional software on the SQL Server.

  http://www.sqldev.net/xp/xpsmtp.htm