Hi All,
I'm wondering if anyone can tell me if it's possible to search for
stored procedures by their contents?
I tend to leave very descriptive notes in stored procedures and
they're beginning to build up in number, so I'm wondering if it's
possible to search in Query Analyzer for stored procedures that
contain certain words / phrases etc.
Alternatively, is there a way to do a system-level select that looks
something like the following pseudo-gibberish (actually, it's actual
gibberish, I guess, rather than pseudo-gibberish):
SELECT * FROM [all stored procedures] where [contents] like '%my
search phrase%'
Any help much appreciated!
Much warmth,
Murray