ps_SearchStoredProcedures provides a "find utility" to search for string in Stored Procedure(s) that you select without dumping to a SQL script file. This stored procedure returns a list of the stored procedures that the string was found in and list of line numbers where the text was found.
Both parameters of the stored procedure allow for wildcards.
EXEC ps_SearchStoredProcedures '%Bob%','%Search%'
--> Searches for "Bob" in the Stored Procedures that have "Search" in the name of the stored procedure
Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
2019-09-20 (first published: 2003-08-26)