SyntaxFix
Write A Post
Hire A Developer
Questions
sp_msforeachdb 'use ?;select name,''?'' from sys.procedures where object_definition(object_id) like ''%text%'''
This will search in all stored procedure of all databases. This will also work for long procedures.