Search among Store Procedures

This query will search within all sproc in DB where string “@PortalIdS” is given. Change this to any string for which you need to search.

    SELECT
        ROUTINE_NAME, ROUTINE_DEFINITION
    FROM
        INFORMATION_SCHEMA.ROUTINES
    WHERE
        ROUTINE_DEFINITION LIKE '%@PortalIDs%'
        AND       ROUTINE_TYPE = 'PROCEDURE'

Another alternate way is

    SELECT   *
    FROM     sys.procedures
    WHERE    OBJECT_DEFINITION(OBJECT_ID) LIKE '%@PortalIDs%'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: