... I am stumped on why that is not working...
Try to read other posts.
Any solution will be very limited to finding very simple queries and only in case if they all are easily can be transformed to something which will satisfy search criteria. Any deviation from this (eg. using comments, table or column aliases, joins, schema names etc.) will stop your solution to find "query" within stored procedure text.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]