functions/ConnectSqlConnection.ps1
|
Function Connect-SqlConnection { <# .Synopsis create a connection to sql instance .Description Using sqldataclient.sqlconnection, create a connection to sql instance return connection .Parameter ConnectionString The SQL Connection as a string that we use to make object SqlConnection .Example Connect-SqlConnection -ConnectionString "Server=.;Integrated Security=True" #> [CmdletBinding()] param ( [string] [ValidateNotNullorEmpty()] $ConnectionString ) $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $ConnectionString try { $SqlSvr = New-Object Microsoft.SqlServer.Management.Smo.Server $SqlConnection return $SqlSvr } catch { Write-Error $_.Exception Throw } } |