Why can’t I select the master database for SQL Server? I have the correct permissions
Why do you want to select master db? What is in their that you need to query?
Always On stats from master views
Okay scratch that. I got it to work in Explorer by using this:
SELECT [database_name]
,[is_failover_ready]
FROM [master].[sys].[dm_hadr_database_replica_cluster_states]
However in the Explorer the is_failover_ready comes back as true/false. In SSMS it comes back as a 0 or 1. Why the change and how can I get that as a value in Alerting?