How to find string in sql stored procedure

 

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%’

Leave a Reply

  

  

  


4 + 3 =