Categories
Database Development

Using listener_name in 4 part naming convention gives sys.servers error

app uses cross db connections, the dbs are in different AG’s, so I need them to use 4 part naming convention – in the place of servername would be listener name, but when I run a simple query like: select * from Listener_Name.DatabaseName.[schemaname].[objectname] I get: Could not find server ‘Listener_Name’ in sys.servers. Verify that the […]