Find the procedure and Functions where a input keyword(s) is present

Posted by Sksamantaray under Sql Server category on | Points: 40 | Views : 1452
I want to find out the procedures or functions which use a keyword Status

SELECT distinct(OBJECT_NAME(id)) spname ,text FROM syscomments WHERE text like '%status%'

Comments or Responses

Login to post response