解决方法
一个选项是创建脚本文件.
右键点击数据库 – >任务 – > 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