Display all stored procedures containing a string
Display all stored procedures containing a string
Programmers always have trouble in finding out the exact stored procedure if you don't have proper documentation.
Beow query will help to find out all the stored procedures containing a particular string.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%User_ID%'
AND ROUTINE_TYPE='PROCEDURE'
if you execute above stored procedure result will be the list of stored procedure containing the string User_ID.
Follow