lokking for a specificy text in a procedure

How can i do a query to return the stored procedures with a specificy text?
regardsselect 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