“Dream is not what you see in sleep, dream is the thing which does not let you sleep.”: Find Text within all stored procedures

Monday, April 11, 2011

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%searchstring%'

The following statement will search all stored proc in database containing the name ‘aspnet_Membership

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%aspnet_Membership_%'

following statement will search a text inside the stored procedure

select * from INFORMATION_SCHEMA.ROUTINES
Where ROUTINE_DEFINITION like '%INNER JOIN aspnet_UsersInRoles UR%'