
stackoverflow.com
https://stackoverflow.com/questions/14704105/searc…
Search text in stored procedure in SQL Server - Stack Overflow
5 I created a procedure to search text in procedures/functions, tables, views, or jobs. The first parameter @search is the search criterion, @target the search target, i.e., procedures, tables, etc. If not specified, search all. @db is to specify the database to search, default to your current database. Here is my query in dynamic SQL.