Skip to content

Instantly share code, notes, and snippets.

@Packet-Lost

Packet-Lost/Test-ReadRouting.ps1

Created August 26, 2017 23:46
Download ZIP

Revisions

  1. Packet-Lost created this gist Aug 26, 2017.
    27 changes: 27 additions & 0 deletions Test-ReadRouting.ps1
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,27 @@
    ##replace variables as needed##
    $Server = 'AvailabilityGroupListener.fqdn.com'
    $Database = 'DatabaseInsideAvailabilityGroup'


    $Connection = New-Object System.Data.SQLClient.SQLConnection
    $Connection.ConnectionString = "Server=$($Server);Database=$($Database);Integrated Security=True;MultiSubnetFailover=True"
    $Connection.Open()
    $Command = New-Object System.Data.SQLClient.SQLCommand
    $Command.Connection = $Connection
    $Command.CommandText = 'Select @@SERVERNAME'
    $Reader = $Command.ExecuteReader()
    $Datatable = New-Object System.Data.DataTable
    $Datatable.Load($Reader)
    $Datatable
    $Connection.Close()
    $Connection = New-Object System.Data.SQLClient.SQLConnection
    $Connection.ConnectionString = "Server=$($Server);Database=$($database);Integrated Security=True;MultiSubnetFailover=True;ApplicationIntent=ReadOnly"
    $Connection.Open()
    $Command = New-Object System.Data.SQLClient.SQLCommand
    $Command.Connection = $Connection
    $Command.CommandText = 'Select @@SERVERNAME'
    $Reader = $Command.ExecuteReader()
    $Datatable = New-Object System.Data.DataTable
    $Datatable.Load($Reader)
    $Datatable
    $Connection.Close()