TN 1156 How to query SQL Server for all Stored Procedures that use a specific table in SQL Server

You can query SQL Server to find all Stored Procedures that access a table (example Runtime DB Tag table) with the the following query:

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Tag%'