Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David McKinney Tables referenced by a stored proc (2000) RE: Tables referenced by a stored proc (2000)
Carlo Romagnano
SSC-Insane
Points: 22599
More actions
December 30, 2008 at 12:47 am
#918811
If you do not use dynamic sql in your sp, you have the sysdepends table with all dependencies between objects.
Here you are:
SELECT object_name(id) as sp,object_name(depid) as dep_obj FROM sysdepends
WHERE object_name(id) = 'mysp_elab'