|
Home > Archive > MS SQL Server > October 2006 > Searching Stored Procedures
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Searching Stored Procedures
|
|
| Jim.Mueksch@wellsfargo.com 2006-10-31, 12:15 am |
| 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
| |
| Arnie Rowland 2006-10-31, 12:15 am |
| 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.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
>
| |
| Aaron Bertrand [SQL Server MVP] 2006-10-31, 7:12 pm |
| 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
>
|
|
|
|
|