Find SP with used table name

SELECT distinct so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%AutoPrintHistory%'

SELECT o.name, o.type_desc, p.name, p.type_desc
FROM sys.sql_dependencies d
INNER JOIN sys.objects o
    ON d.object_id = o.object_id
INNER JOIN sys.objects p
    ON d.referenced_major_id = p.object_id
    AND o.name = 'RejectionReason'
or

SELECT o.name, t.TABLE_NAME, c.text
  FROM syscomments c
  JOIN sysobjects o
    ON c.id = o.id
  JOIN INFORMATION_SCHEMA.Tables t
    ON  c.text LIKE '%RejectionReason%'
or

EXEC sp_depends @objname = N'RejectionReason';

댓글

이 블로그의 인기 게시물

Ubuntu Server에 GitLab 설치 Jenkins BlueOcean 연동 + MSBuild

c# Create Zip File Using 7-zip