This query will give you the list of stored procedure or sql server objects that contains the word profile in there definition or data content. select routine_name from information_schema.routines where object_definition(object_id(routine_name)) like ‘%profile%’ OR select object_name(id),* from sys.syscomments where text like ‘%text%’