Lots of stored procedures on the ms sql 
and you're looking for one of wich text contains 'bla'
so here is the query :
     SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE /*ROUTINE_NAME */ROUTINE_DEFINITION LIKE '% sp_executesql%' 
    AND ROUTINE_TYPE='PROCEDURE'
here
 ROUTINE_NAME: name of stored procedure
 ROUTINE_DEFINITION: text of stored procedure
No comments:
Post a Comment