September 22, 2007 at 1:05 pm
Comments posted to this topic are about the item how to test connectivity for a linked server
September 16, 2011 at 12:39 pm
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.
May 12, 2016 at 7:06 am
Thanks for the script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy