Snipplr comments feed https://snipplr.com/ Sun, 19 Apr 2026 08:46:17 +0000 https://snipplr.com/view/43820/find-sp-or-table-name-in-all-stored-procs <p>How can I find if particular table is being used in the stored procedure? How to search in stored procedures? --Searching for Empoloyee table SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%' GO --Searching for Empoloyee table and RateChangeDate column together SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%' AND OBJECT_DEFINITION(OBJECT_ID) LIKE '%RateChangeDate%' GO</p> Wed, 08 Dec 2010 16:45:58 UTC https://snipplr.com/view/43820/find-sp-or-table-name-in-all-stored-procs