MSSQL - List all stored procedures related to specified table

Watch on YouTube




Select sys.sysobjects.name, sys.sysobjects.xtype FROM

sys.syscomments inner join sys.sysobjects on sys.syscomments.id = sys.sysobjects.id
where sys.syscomments.text like '%TABLE_NAME%' and sys.sysobjects.xtype = 'P'