>Naomi,
>
>Thanks for the code and link, they helped.
>
>Is there similar code to search code contained in all user defined functions?
>
>- Tom A.
Take a look into INFORMATION_SCHEMA.Routines system view. It has ROUTINE_DEFINITION column.
I'll also make a search on T-SQL forum as I remember we discussed a similar problem recently.
If it's not broken, fix it until it is.
My Blog