Find procedure names which contains the given text

Sunil Soni
Posted by Sunil Soni under Sql Server category on | Points: 40 | Views : 2103
Declare @strText varchar(100);
set @strText = '%life_renewal_comm%'
Select distinct name from sysobjects SO
inner join syscomments SC on =
where SO.type='p' and SC.text like @strText order by

Comments or Responses

Posted by: T.saravanan on: 9/14/2011 Level:Silver | Status: [Member] [MVP] | Points: 10
Kindly post your code inside the code tag.

Login to post response