'Sql server availability group listeners in query
My goal is to write query in SSMS against 2 databases that are in 2 different availability groups with 2 different listeners.
Is it possible to use listeners in the query after FROM clause? Like SELECT * FROM Listener1.table1?
Should I create linked server and set secondary node read-only routing? Microsoft documentation says it is possible on sql server standard, but this option is disabled.
Should I join these 2 databases under one AG group with one listener?
Any advices how to set up sql server to use it like this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|