Take a look in syscomments for the text and join to sysobjects for the object type and name
solved How can I find all occurrences of particular text within all stored procedures in my database? [closed]
Take a look in syscomments for the text and join to sysobjects for the object type and name
solved How can I find all occurrences of particular text within all stored procedures in my database? [closed]