右键点击数据库 – >任务 – > Generete脚本

然后,您可以选择所有存储过程,并使用所有sp生成脚本.所以你可以从那里找到参考.

要么

-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'CreatedDate' + '%'
GO

-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '%' + 'CreatedDate' + '%'
GO

来源SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name