Finding all the Stored Procedures which are having a specific Column Values inside that SP.

Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 390
We have to use information_schema in-built Sql Server Object,in my case ACTIVE is a Row Value which i need to find inside all Stored Procedures.
So,below script will return all Stored Procedure which will contain ACTIVE word.
routine_name as [Procedure],
Routine_Definition [Procedure Code],
specific_schema as [DB Schema],
specific_catalog as [DB Name]
From information_schema.routines
Where routine_definition like '%ACTIVE%'
and routine_type = 'Procedure';

Comments or Responses

Login to post response