[Solved] How can I find all occurrences of particular text within all stored procedures in my database? [closed]

by

[ad_1]

Take a look in syscomments for the text and join to sysobjects for the object type and name

sysobjects

syscomments

[ad_2]

solved How can I find all occurrences of particular text within all stored procedures in my database? [closed]