how to test connectivity for a linked server

• kodracon

  Ten Centuries

  Points: 1027

  More actions

  September 22, 2007 at 1:05 pm

  #174924

  Comments posted to this topic are about the item how to test connectivity for a linked server

• Darren Weiner

  SSC Rookie

  Points: 44

  More actions

  October 29, 2007 at 6:54 am

  #746226

  why not just use:

  DECLARE @test-2 BIT

  EXEC @test-2 = SP_TESTLINKEDSERVER [mylinkedservername]

  IF @test-2 = 0

  BEGIN

  PRINT 'test failed'

  END

  else

  BEGIN

  PRINT 'test succeeded'

  END

• Mike Good

  SSCertifiable

  Points: 7415

  More actions

  September 16, 2011 at 12:39 pm

  #1382727

  I agree, sort of. In tests on SQL 2005, seems to me the proc call needs to be in TRY/CATCH else control does not flow down to the PRINT stmts when linked server is not available. But I have not been able to simulate this problem on SQL 2008 R2. Maybe MS have implemented TRY/CATCH internally.

  Thanks to the author, though, for bringing light to SP_TESTLINKEDSERVER, it's new for me.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 12, 2016 at 7:06 am

  #1878562

  Thanks for the script.