List out all table procedures or specified table/column in sqlserver

List out all procedures which are used specific table

SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on sc.id=so.id WHERE sc.text LIKE '%tablename%'


Get List of programs that used(mentioned) particular  column in side the query.

•  This script search stored procedures, views, functions as well other objects.

           SELECT OBJECT_NAME(OBJECT_ID), definition FROM sys.sql_modules WHERE              definition LIKE '%' + 'EMAIL' + '%'

• This script search only stored procedure for specified column.

            SELECT DISTINCT OBJECT_NAME(OBJECT_ID), object_definition(OBJECT_ID)

            FROM sys.Procedures WHERE object_definition(OBJECT_ID) LIKE '%' + 'EMAIL' + '%'