Finding a text from all SP(SQL)

Select Distinct SO.Name from sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id=SC.ID and
SO.Type = 'P' AND SC.Text not LIKE '%nolock%' and so.name like'wsp%' order by SO.Name

Comments