Re: How to genericaly search the entire db for any text string in any stored procedure, function, table definition, agent job, etc. Any one command or anyone have a stored proc that does this wide search?

Tech-Archive recommends: Speed Up your PC by fixing your registry

I normally do a like on syscomments.

select distinct object_name(ID) from syscomments where text like '%my search
phrase goes here%'

--
http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DR" <softwareengineer98037@xxxxxxxxx> wrote in message
news:OorWu27NIHA.5988@xxxxxxxxxxxxxxxxxxxxxxx
How to genericaly search the entire db for any text string in any stored
procedure, function, table definition, agent job, etc. Any one command or
anyone have a stored proc that does this wide search?



.