lokking for a specificy text in a procedure

How can i do a query to return the stored procedures with a specificy text?
regards
select object_name(id) from syscomments where text like '%YouSearchText%'
order by 1
"EdwinSlyfingster" wrote:

> How can i do a query to return the stored procedures with a specificy text?
> regards
sql