SELECT DISTINCT so.ID, so.name AS 'Procedure Name' , oo.name AS 'Table Name'
FROM sysdepends d, sysobjects so, sysobjects oo
WHERE so.id=d.id
AND so.name= 'Stored_Proc_Name' -- Enter Your
stored Procedure Name here
AND oo.id=d.depid
ORDER BY so.NAME,oo.NAME
Comments
Post a Comment