Can you connect to remote instance with Get-SqlData

Sep 20, 2011 at 9:40 PM

Is it possible to connect to a remote instance,port with: Get-SqlData?  LIKE: Get-SqlData "dbhost1,3180" Orchestrator "SELECT * FROM dbo.test"

Coordinator
Sep 27, 2011 at 2:02 AM

Yes it works fine for me:

 

get-sqldata -sqlserver "sql2k8r2.corp.contoso.com,36301" -dbname master -qry "select name from sysdatabases"