Find sp names which contains the given text

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

Comments or Responses

Login to post response