SELECT DISTINCT OBJECT_NAME(C.ID) FROM syscomments C INNER JOIN FROM sys.procedures P ON P.Name=OBJECT_NAME(C.ID) WHERE C.Text LIKE '%Search_String%' AND P.type = 'P'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)