Finding TableName Reference In Stored Procs Or DTS Jobs

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  August 10, 2004 at 9:27 am

  #86042

  I am trying to write a script which will search all stored procedures and DTS packages for a database table name.  Any help out there?

• JBZ

  Old Hand

  Points: 370

  More actions

  August 10, 2004 at 9:35 am

  #518342

  Something like this?

  select o.name from sysobjects o

  inner join syscomments c

  on o.id = c.id

  where text like '%table_name%'

   

  Julia