we have a new SQL site - and included Availability Group in the install.
set up is 2 servers - with 2 availability groups (AG1 and AG2) on each one.
each of the availability groups has a Listener (AGL1 and AGL2)
when running SSIS packages, we use the listeners to connect to the "right" PRIMARY node to enable updates to occur
in SSMS, can connect to the listener as a "database" connection
but would also like to be able to run a query across the groups
e.g.
when on the "secondary" node, execute a SQL update statement such as
INSERT INTO [AGL1].[WarehouseDB].[dbo].TestTable...
is this possible - i.e. can the AGL "name" be resolved (without using Linked servers)
??