quick SQL connectivity test with auth

quicksqltest.ps1

#http://irisclasson.com/2013/10/16/how-do-i-query-a-sql-server-db-using-powershell-and-how-do-i-filter-format-and-output-to-a-file-stupid-question-251-255/
$connectionString = "Data Source=localhost\SQLEXPRESS;Integrated Security=false;Database=dbname;user id=sqluser;password=sqluserpassword;Connect Timeout=3;"
$sqlConn = new-object ("Data.SqlClient.SqlConnection") $connectionString
$sqlConn.Open()
$sqlcmd = New-Object System.Data.SqlClient.SqlCommand
$sqlcmd.connection = $sqlConn
$sqlcmd.commandtext = "SELECT * FROM information_schema.tables"
$sqlreader = $sqlcmd.ExecuteReader()
$table = new-object “System.Data.DataTable”
$table.Load($sqlreader)
$table
$sqlconn.Close()
$sqlcmd = ""