Search a particular text in all the stored procedure.

Ndebata
Posted by Ndebata under Sql Server category on | Points: 40 | Views : 1679
Generate a list of stored procedure names where a particular text is used.

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%SearchText%'

Thanks,
Debata

Comments or Responses

Posted by: T.saravanan on: 4/26/2011 Level:Silver | Status: [Member] [MVP] | Points: 10
Hi Debata,

Kindly post your code inside the code tag its looking good.

Login to post response