Home Forums Article Discussions Article Discussions by Author Discuss content posted by Chris Morton how to test connectivity for a linked server RE: how to test connectivity for a linked server

  • 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