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]

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 19, 2016 at 6:49 am

  #1880180

  Thanks for the script.

• Konstantin Taranov

  SSCertifiable

  Points: 6498

  More actions

  May 27, 2016 at 2:07 am

  #1881750

  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

  May 27, 2016 at 9:11 am

  #1881812

  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]