标识在SQL Server中承载特定字符串的存储过程和触发器

下载SQL Digger-工作是一种享受

http://www.sqldigger.com/

在SqL2005中:

SELECT Name 
FROM sys.procedures 
WHERE OBJECT_DEFINITION(object_id) LIKE '%Table1%' 

或者在SQL Server Management Studio中,右键单击表并选择“查看依赖项”,但这找不到使用动态SQL引用表1的过程。

更多信息: http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html

尝试以下方法之一:

select sysobjects.name from syscolumns left join sysobjects on sysobjects.id = syscolumns.id where syscolumns.name like '%Table1%' order by 1

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Table1%'
GO