MS SQL 2000 stops sending mail.

• Roust_m

  SSCoach

  Points: 17410

  More actions

  February 2, 2004 at 12:11 am

  #83923

  Hi!

  I have a database server (MS SQL 2000 sp3) that sends mail messages via MS Exchange 2000 sp3. When system administrator reboots his mail server, the database server stops sending mail until rebooted.

  The only error, I found, that can be related to this:

  ATTENTION: SQLSERVERAGENT reported the following error...

  [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00] 

  What can be done about this?

   

  Thanks.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 2, 2004 at 7:16 am

  #492467

  http://support.microsoft.com/default.aspx?scid=kb;en-us;328197&Product=sql2k