SQL Tutorial - How to search text in a Stored Procedure
Learn how to search text in a stored procedure, if you want to know what stored procedures are inserting, updating or deleting data in a table this tutorial will show you how. Using a combination of system catalog views, sys.objects and sys.sql_modules you will not only be able to find all stored procedures that reference a table but other objects too such as views, triggers and functions.
Further reading can be found on Microsoft Docs:
sys.objects
https://docs.microsoft.com/en-us/sql/...
sys.sql_modules
https://docs.microsoft.com/en-us/sql/...