Sample Header Ad - 728x90

Pairing Query Store Read/Write Status with Enabled Status

1 vote
1 answer
101 views
I am able to find if Query Store is enabled: SELECT name, is_query_store_on from sys.databases I am able to query a specific database to determine the Query Store Read/Write Status: SELECT actual_state_desc from sys.database_query_store_options How do I join the two results to have the information in one table? They do not have a common field, and I assume I could write a CROSS JOIN to match the two tables up, but am unsure how without that common field.
Asked by CrushingIT (33 rep)
Dec 16, 2021, 07:00 PM
Last activity: Dec 16, 2021, 08:02 PM