find a word in all stored procedures.. 1

[jonasggg]

hello.
i mispelled a same word in more than 20 stored procedures and i cant figure it out wich of them has it to correct them.
is there a possibility to find this word in all sp at once?
thanks in advance.

jonas

 

[SQLDenis]

yep, here is an example

use pubs

select specific_name from information_schema.routines
where routine_definition like '%titleauthor%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/