Saturday, September 13, 2014

Find Stored Procedure Containing by Table Name


SELECT DISTINCT t.name [TableName], p.name [ProcedureName]
FROM sys.objects t
LEFT JOIN sys.sql_dependencies d ON
    d.referenced_major_id = t.object_id
LEFT JOIN sys.objects p ON
    p.object_id = d.object_id  
WHERE t.type = 'u'
and t.name like '%tbl_Order%'


No comments:

Post a Comment