Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
We use a slightly modified approach that returns results from more than stored procedures (although it could be modified to return only results for stored procedures). We use this code in a stored procedure that requires a parameter containing the text to search for.@StringToFind...
How to find all the Stored Procedures having a given text in it.
This is an alternative for "Find all Stored Procedures having a given text in it"