Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Testing all Linked Servers in all SQL SERVER servers with Powershell Expand / Collapse
Author
Message
Posted Thursday, April 16, 2009 1:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 15, 2016 5:23 PM
Points: 165, Visits: 836
Comments posted to this topic are about the item Testing all Linked Servers in all SQL SERVER servers with Powershell

$hell your Experience !!!
Post #698851
Posted Thursday, May 19, 2016 6:49 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:55 AM
Points: 8,101, Visits: 812
Thanks for the script.
Post #1787661
Posted Friday, May 27, 2016 2:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 4:30 AM
Points: 1,572, Visits: 396
Pure powershell solution from Thomas LaRock:https://github.com/ktaranov/sqlserver-kit/blob/master/PowerShell/SQL_Server_linked_server_connection_check.ps1
Post #1790198
Posted Friday, May 27, 2016 9:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 15, 2016 5:23 PM
Points: 165, Visits: 836
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 !!!
Post #1790290
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse