How do you use cloud databases? Take the survey.
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