sql , get all stored procedures containing specified string:

sql , get all stored procedures containing specified string:

SELECT Distinct SO.Name

FROM sysobjects SO (NOLOCK)

INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID

AND SO.Type = 'P'

AND SC.Text LIKE '%KEYWORD%'

ORDER BY SO.Name






sql query to get all tables containing specified column



SELECT OBJECT_NAME(object_id)

FROM sys.columns

WHERE name = '';