I'm trying to find a way to filter out all "sys" stored procedures from profilter RPC events.
Firstly - I do not have a quick way of doing so (a filter that would enable me to filter by store proc's owner = sys).
I then tried using TextData and NOT LIKE but I do not know how to use escape character literally, most (maybe all) procs are displayed in TextData like this:
But I can't simply write " not like '%[MyDB].[sys].sp_%'
This doesn't work: " not like '%\[MyDB\]\.\[sys\]\.sp\_%'
This doesn't work either: " not like '%[[MyDB]][.][[sys]][.]sp[_]%'
View Complete Post