Stored Proc Dependency

• lucky-80472

  SSCertifiable

  Points: 7793

  More actions

  June 2, 2006 at 1:29 pm

  #113304

  Hello,

  Does anybody have an idea on how to script the logic to find out the stored proc dependency across databases in a server?

  I'm thinking of a common logic where it should be useful to figure out the table objects being used in the stored procedures.

  Any ideas would be greatly helpful.

  Thanks in advance and have a great weekend.

  
  Lucky

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  June 2, 2006 at 3:25 pm

  #641535

  SQL uses sp_MSdependencies SP to get this info, if you run

  sp_helptext sp_MSdependencies you can see what is in the SP and presumably cobble together what you need.