Search Procedures On The Basics Of A Column Name

Search procedures on the basic of a column name. You can search only in Stored procedure and All objects as well. So, added 2 queries for the same.

-- Display the list of All Objects which is having name column
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'name' + '%'
GO

-- Display the list of Stored Procedure which is having name column
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '%' + 'name' + '%'
GO