SELECT name FROM sys.procedures WHERE Object_definition(object_id) LIKE '%Order%'
SELECT name FROM sys.procedures WHERE Object_definition(object_id) LIKE '%Order%' and Object_definition(object_id) NOT LIKE '%/**%'
SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFOMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ('%YOURSEARCHTEXT%')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)