marksmithy69
Programmer
I am a total newbie to SQL Server, so I apologize for the simple question. Is there a way to search through all stored procedures for a text string? Thanks a lot.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE 'your search string here'
AND ROUTINE_TYPE='PROCEDURE'