Testing all Linked Servers in all SQL SERVER servers with Powershell

Question

Post reply

Testing all Linked Servers in all SQL SERVER servers with Powershell

Laerte Poltronieri Junior-367636

Hall of Fame

Points: 3314
More actions
April 16, 2009 at 1:43 pm

#384379

Comments posted to this topic are about the item Testing all Linked Servers in all SQL SERVER servers with Powershell
$hell your Experience !!![/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

akljfhnlaflkj

SSC Guru

Points: 76202

May 19, 2016 at 6:49 am

#1880180

Thanks for the script.

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 2

Pure powershell solution from Thomas LaRock:https://github.com/ktaranov/sqlserver-kit/blob/master/PowerShell/SQL_Server_linked_server_connection_check.ps1

Laerte Poltronieri Junior-367636 Hall of Fame Points: 3314 More actions · Answer 3

My good friend Tom has a very cool solution too, but this script was published in SSC in first time I guess in 2008 or 2009 (you can check by the code still using -trap- for error handling.. I~ve wrote to PowerShell 1.0). I am not sure why it was published again and with 2016 date

$hell your Experience !!![/url]