Question : find column in all stored procedures sql server
Answered by : innocent-iguana-k4zdx6sm0m51
-- Search column in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'BusinessEntityID' + '%'
GO
Source : https://blog.sqlauthority.com/2012/07/19/sql-server-find-column-used-in-stored-procedure-search-stored-procedure-for-column-name-part-2/ | Last Update : Tue, 19 May 20