Try this:

-- Search for specific text in a Function or Stored Procedure
SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%project name%'

Hope that helps!

Bill Finch MCSE,CCNA
Database Administrator
LCG Technologies, Inc.

-----Original Message-----
From: Aradana Liyanage
[mailto:mssqldba-ezmlmshield-x94170326.[Email address protected]
Sent: Saturday, September 29, 2007 5:03 AM
To: LazyDBA Discussion
Subject: Find a spesific text from a Sp

Hi Gurus



I am using SQL 2000.

My web app uses Sql stored procedures. I just wanted to find a specific
stored procedure which contains some specific text



Eg : I wanted to find a sp which has a text "project_name" in it



Is this possible?



Aradhana





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




This email, its electronic document attachments, and the contents
of its website linkages may contain confidential information. This
information is intended solely for use by the individual or entity
to whom it is addressed. If you have received this information in
error, please notify the sender immediately and arrange for the prompt
destruction of the material and any accompanying attachments.


MS Sql Server LazyDBA home page