Skip to content

Instantly share code, notes, and snippets.

@martin9700

martin9700/Invoke-SQLQueryEnd2.ps1

Created November 30, 2014 12:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save martin9700/ba9bf0455e2a008c150c to your computer and use it in GitHub Desktop.
Save martin9700/ba9bf0455e2a008c150c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Invoke-SQLQueryEnd2.ps1
ForEach ($SQLServer in $Instance)
{ $ConnectionString = "data source=$SQLServer,1433;Initial catalog=$Database;$Security;$MSF"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = $ConnectionString
$SqlCommand = $SqlConnection.CreateCommand()
$SqlCommand.CommandText = $Query
$DataAdapter = New-Object System.Data.SqlClient.SqlDataAdapter $SqlCommand
$DataSet = New-Object System.Data.Dataset
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment