Pasted

# invoke sql cmd
[System.Reflection.Assembly]::LoadWithPartialName("System.Data") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("System.Data.SqlClient") | Out-Null
 
function Invoke-SqlcmdCustom {
    [CmdletBinding()]
    Param(
        [parameter(Mandatory=$false)]
        [string]$ServerInstance,
        [parameter(Mandatory=$false)]
        [string]$Database,
        [parameter(Mandatory=$false)]
        [string]$Query
    )
    $connstr = "Server=$($ServerInstance);Database=$($Database);Trusted_Connection=True;"
    $conn = new-object System.Data.SqlClient.SqlConnection($connstr)
    $conn.Open()
    $cmd = new-object  System.Data.SqlClient.SqlCommand($Query, $conn)
    $dt = new-object System.Data.DataTable
    $dt.Load($cmd.ExecuteReader())
    $cmd.Dispose()
    $conn.Close()
    $conn.Dispose()
return $dt.Rows
}