search string in stored procedures sql server

SELECT SO.NAME, SC.TEXT
FROM SYS.SYSOBJECTS SO
JOIN SYS.SYSCOMMENTS SC ON SO.ID = SC.ID
WHERE SC.TEXT LIKE '%aranan%'
AND SO.TYPE = 'P'

Yorumlar