Home / Software / Tips and Tricks / How to search for a text in all stored procedure and UDF in the database.

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

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

Status:    Resolved.


User the system table INFORMATION_SCHEMA.ROUTINES for the search.