Forum Discussion

Copper Contributor

Jun 29, 2023

SQL Monitoring Question

How do I see all queries run between 2:00 am and 2:30 am on a SQL Server? Am I also able to see the query text that was used?

Bronze Contributor

Jun 30, 2023

HDale17 , if you haven't implemented a query audit, then it's not really possible to get queries afterwards.

In newer SQL Server version you can enable the "Query Store" feature, see