Searching Stored Procedures

Hi,

We are using SQL Server 2005 and SS Management Studio.    We
have a database that contains about 500 stored procedures.   I want to
quickley search through those stored procedures looking for a string of
text.

How can I do this?   QuickFind requires me to have the
procedure open in an editing window before it will search.  I want to
do it without opening 500 stored procedures.


Thanks,
Jim

This might work for you.

SELECT ROUTINE_NAME
FROM   INFORMATION_SCHEMA.ROUTINES
WHERE  ROUTINE_DEFINITION LIKE '%Search Criteria Here%'

-- 
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience. 
Most experience comes from bad judgment. 
- Anonymous

You can't help someone get up a hill without getting a little closer to the 
top yourself.
- H. Norman Schwarzkopf


<Jim.Mueksch@wellsfargo.com> wrote in message news:1162247107.522841.188880@b28g2000cwb.goo
glegroups.com...
> Hi,
> 
>       We are using SQL Server 2005 and SS Management Studio.    We
> have a database that contains about 500 stored procedures.   I want to
> quickley search through those stored procedures looking for a string of
> text.
> 
>        How can I do this?   QuickFind requires me to have the
> procedure open in an editing window before it will search.  I want to
> do it without opening 500 stored procedures.
> 
> 
> Thanks,
> Jim
>

SELECT [name]
FROM sys.procedures
WHERE OBJECT_DEFINITION([object_id]) LIKE '%a string of text%'



<Jim.Mueksch@wellsfargo.com> wrote in message
news:1162247107.522841.188880@b28g2000cwb.googlegroups.com...
> Hi,
>
>       We are using SQL Server 2005 and SS Management Studio.    We
> have a database that contains about 500 stored procedures.   I want to
> quickley search through those stored procedures looking for a string of
> text.
>
>        How can I do this?   QuickFind requires me to have the
> procedure open in an editing window before it will search.  I want to
> do it without opening 500 stored procedures.
>
>
> Thanks,
> Jim
>