How to find a String/Character/Table/Function used in a Procedure

This is very easy to find any specific string or character you have used in your procedure. You can run the below sql statement and pass the exact string in place of Your_String area. You can find out the list of all the procedures in which that string is implemented.

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Your_String%'

GO