Hi All.......
I want to get all the queries ran against a SQL database during a certain time frame.
Right now, I have TOP 50, TOP 1000.........
But I want to view all the queries that were performed against a SQL database . Is there a way to get that detail ?
You cannot, doing so would require much more overhead than would be desired from a 24x7 monitoring solution. To do this, you'd be best off with something like Profiler (or Extended Events), which is/are a free native SQL Server solution.
Ok Thank you!!
Ok Thank you!!
