Dependencies

• kiran .r

  Newbie

  Points: 4

  More actions

  January 25, 2006 at 10:42 am

  #167272

   

  Is there a way to query whether a table with no dependencies on it in sql server is referenced in any stored procedures without going through each procedure individually?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 25, 2006 at 10:47 am

  #616979

  Try this.

  there as another post that is similar to this but I don't know the whole answer

  select so.name

  from syscomments sc

  join sysobjects so on sc.id = so.id

  where sc.text like '%Mytable%'

   

• Fred Williams-134192

  SSCrazy

  Points: 2482

  More actions

  January 25, 2006 at 10:58 am

  #616982

  Check out the Xfind script at:

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1124