>Is there a way to find a string in all of the stored procedure for a database?
>
>I know it passable. Any one done this before?

This is where I am happy to use SQL Programmer... it has a search that will search for a string in any objects specified, I usually only search in SP's, but you can search in tables, triggers, etc.

BOb