Re: Can I search for a string in a set of stored procedures?

COHENMARVIN@[EMAIL PROTECTED]
 wrote:

> I found that I'm making an error in my 'case' statements, and now I
> want to go through a database full of many stored procedures to find
> that error in some of them and to fix it.  Is there any way to do a
> search through multiple stored procedures at once?  I don't see one in
> my version of Sql Server Management Studio?

I think this is right (I mostly still work with 2K which uses older
methods):

select o.name
from sys.objects o
  join sys.sql_modules m on o.object_id = m.object_id
where m.definition like '%text%'