How to detect if a Linked Server is Running

• Gabriel-133640

  Newbie

  Points: 5

  More actions

  April 15, 2004 at 6:59 pm

  #76151

  Hi

  I have a SP, 'MYSP', that includes this line: EXEC sp_catalogs 'MyLinkedServer'. If MyLinkedServer is running, this SP gives me some information about Databases in that server. If MyLinkedServer is not running, SQL Server raises an error, which is fine, but I can't use the @@ERROR to trap the exception and MYSP execution stops.

  Does anybody knows how can I detect if 'MyLinkedServer'  is running before I send any command/sentence/anything to it?  Or how can I trap the error and finish MYSP? 

  Thank you

  Gabriel

• April 19, 2004 at 8:00 am

  This was removed by the editor as SPAM

• lakusha

  SSCommitted

  Points: 1857

  More actions

  April 19, 2004 at 8:46 am

  #503353

   

  Take a look at the SQL2K ressource kit. There used to be an ODBC Ping utility in there (or something similar).

   

  Eric