Search stored procedures for a certain text string

microsoft newsgroup web access
dot net \| ms sql \| ms access \| office \| windows \|

Search stored procedures for a certain text string

We have a database with approx 120 stored procedures in it and no access
to the original scripts.

Is there any way to search a database's stored procedures for a certain
code text ie: a search for "select datediff" code in all the stored
procedures.

Thanks220 500645 <50VFd.78536$Xk.49221@pd7tw3no>
X-Trace-PostClient-IP: 24.86.118.124
From: Mark

Fri, 14 Jan 2005 19:24:49 GMT Mark

Re: Search stored procedures for a certain text string

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%datediff%'

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

"Mark" wrote in message
news:50VFd.78536$Xk.49221@pd7tw3no...
> We have a database with approx 120 stored procedures in it and no access
> to the original scripts.
>
> Is there any way to search a database's stored procedures for a certain
> code text ie: a search for "select datediff" code in all the stored
> procedures.
>
> Thanks

220 500648
From: "Adam Machanic"
References: <50VFd.78536$Xk.49221@pd7tw3no>
Subject: Re: Search stored pr

Fri, 14 Jan 2005 14:30:55 -0500 "Adam Machanic"