InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:54:30 GMT20http://www.sqlservercentral.com/Forums/Topic1382156-1351-1.aspxIf you get-member in get-sqldata you will see that it returns a System.Data.DataRow and the properties related to your query. This is what you need to use :In you query,the name of the Instance is InstanceName rigth ?Change you script to :$myserver = $_.InstanceName and will work :)Sun, 18 Nov 2012 13:01:02 GMTLaerte Poltronieri Junior-367636http://www.sqlservercentral.com/Forums/Topic1382156-1351-1.aspxI am trying to use a SQL Table to loop through SQL Instances and pass the Instance to a script:$DestinationSQLServer = 'coaidera01\idera'$DestinationDBName = 'CTM_Monitoring'$DestinationQry = "select InstanceName from COA_SQLServerInstanceInfo WHERE InstanceName Like 'coaidera01\idera'"$SQLSvr = get-SqlData -sqlserver $DestinationSQLServer -dbname $DestinationDBName -qry $DestinationQry$SQLSvr | foreach { $myserver = $_$MySQL = new-object Microsoft.SqlServer.Management.Smo.Server $myserver;------------------------------------------------------------------------------I get this error: The following exception was thrown when trying to enumerate the collection: "Failed to connect to server System.Data.DataRow.".Any CluesWed, 07 Nov 2012 13:27:13 GMTgeorge.auckland 44813