Sep 172010
 
 
I had to write a script that ran a SQL SP this week and found that this was not the most straight forward thing to do.
 
This was how I managed do it.
 
 

    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $SqlConnection.ConnectionString = "UID=”DBUID”;PWD=”password”;Server=”IP”;Database=”DB”;Integrated Security=False"
    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $SqlCmd.CommandText = "sp_name"
    $SqlCmd.Connection = $SqlConnection
    $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SqlAdapter.SelectCommand = $SqlCmd
    $DataSet = New-Object System.Data.DataSet
    $SqlAdapter.Fill($DataSet) | Out-Null
    $SqlConnection.Close()
    $DataSet.Tables[0]

All you Powershell gurus are more than welcome to suggest a better way…..

Post to Twitter

Twitter links powered by Tweet This v1.8.3, a WordPress plugin for Twitter.