Find Column In All Stored Procedures Sql Server

[Solved] Find Column In All Stored Procedures Sql Server | Sql - Code Explorer | yomemimo.com
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

Answers related to find column in all stored procedures sql server

Code Explorer Popular Question For Sql