Searching of key work in stored procedures

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  April 5, 2004 at 5:31 am

  #160797

  I have got a scnerio that i have to search a key word in my all 426 stored procedures  ,There is a command so that i can find my that particular keyword in all the sps .

  Thanks

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  April 5, 2004 at 7:07 am

  #501738

  This will search the procedures in a database but will not find the text in encrypted procedures

  declare @keyword varchar(20)

  set @keyword = 'keyword'

  select distinct s.name 

  from sysobjects s

  inner join syscomments c

  on c.id = s.id

  and charindex(@keyword,c.text) > 0

  where s.type = 'P'

  Alternatively script all the procedures to separate files and use the DOS command FINDSTR to search the text files

   

  Far away is close at hand in the images of elsewhere.
  Anon.