SQL 2000- How to determine if SQLMail is setup (TSQL)

• Ryan D.

  SSCommitted

  Points: 1595

  More actions

  May 7, 2008 at 7:49 am

  #185189

  Hi

  Is there a way to determine if SQL mail is enabled through TSQL statement. I'm trying to verify my list of servers that uses SQLMail. We are transitionng some of our exchange servers and would like to make sure I have accounted for all the SQL servers. I can go through EM for each server and check, however, I wanted to find a quicker way to to do.

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  May 7, 2008 at 8:39 am

  #811843

  xp_startmail

  Will start or return "started" or return an error.