Training: Reporting in SQL Monitor. Watch now.
Searching SQL Query text for keywords
We are having some pen testing done against our systems and some of the code is 15-20 years old. One of the sql injection statements ran an update on all the rows but the testers are not sure which one it was.
I am obviously keen to find out what the statement was, I have searched against dm_exec_query_stats but it looks like they refreshed a day after the statement was ran. My next thought was that SQL Monitor may have a record, is there any way i can search for any SQL statements that contain a table keyword?
0 · Share on Twitter