Wondering if anyone had any ideas on this dilema?
I want to be able to trace code through my database, looking for certain patterns of sql code.
If the code being run, does not look genuine, i want to be able to lock the account that is sending it.
I am considering looking at the dmv's and pulling out the running queries and then locking the account, and send an alert.
Are there better ways of doing this?