SQL to list all Procs using TABLE abc or VIEW xyz

• Express12

  SSCoach

  Points: 18514

  More actions

  June 28, 2006 at 1:32 pm

  #169443

  Need some sql to list all PROCS which use TABLE "abc" or VIEW "xyz"

  thx in advance 

  BT

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  June 28, 2006 at 1:48 pm

  #646475

  Assuming your dependencies are in order you can query sysobjects and sysdepends... something like this should work:

  SELECTso2.name

  FROMsysobjects so

  JOINsysdepends sd

  ONso.id = sd.depid

  JOINsysobjects so2

  ONsd.id = so2.id

  WHEREso.name = 'table_or_view_name'

  ANDso2.xtype = 'P'