Cmdlets/Test-SqlConnection.ps1
|
<#
.Synopsis Tests to see if there is a connection. .Description Tests to see if there is a connection, use the -All switch to determine if there are any connections. .Parameter ConnectionName User defined name for the connection to test for. .Parameter All Returns true if there are any connections, otherwise false. #> Function Test-SqlConnection { [cmdletBinding(DefaultParameterSetName="single")] Param([Parameter(ParameterSetName="single",Position=0)][ValidateNotNullOrEmpty()][Alias("cn")][string]$ConnectionName = "default" , [Parameter(Mandatory, ParameterSetName="all")][switch]$All) If($all.IsPresent -and $Script:Connections.Count -gt 0) { return $true } ElseIf($Script:Connections.ContainsKey($ConnectionName)) { return $true } Else { return $false } } Set-Alias -Name tsc -Value Test-SqlConnection Export-ModuleMember -Function Test-SqlConnection -Alias tsc |