Test Your Linked Server Connections

Question

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Paulo A. Nascimento SSCommitted Points: 1717 More actions · Answer 1

Hi

Maybe I'm loosing something here, but what is the real advantage of this code against 'sp_linkedservers' ?

Cheers,

--

Paulo

Robert.Sterbal SSCrazy Points: 2855 More actions · Answer 2

Paulo,

This code stores the results of a test if the link server is available. A lot of us deal with intermittent network connections.

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 3

Another solution with powershell script by Thomas LaRock:

https://github.com/ktaranov/sqlserver-kit/blob/master/PowerShell/SQL_Server_linked_server_connection_check.ps1

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 17, 2016 at 6:31 am

Thanks for the script.

Glen Cooper SSCommitted Points: 1917 More actions · Answer 5

Nice article.

I recently wrote a Visual Basic 2005 front-end to test arbitrary connection strings (they may be shared using a simple SQL Server database).

Article (unpublished):

Source:

Your script would make a nice addition to this app.