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: 22597
More actions
January 2, 2009 at 1:23 am
#920120
Please, try this one:
exec sp_MSdependencies N'[dbo].[mysp_elab]', null, 1053183
Third parameter is 1053183, that means only table named in the sp.
Without parms, it returns all dipendencies: table used in the sp and their FK.