SELECT distinct so.nameFROM syscomments scINNER JOIN sysobjects so ON sc.id = so.idWHERE charindex('table_name', text) > 0
This returns the following showing both proc,function and trigger
No comments:
Post a Comment