How to search for a text in all stored procedure and UDF in the database.

Validating the user

Updated:  09/16/2013 13:09 PM
Author:  Shiju Mathews

Status:    Resolved.

User the system table INFORMATION_SCHEMA.ROUTINES for the search.