[Solved] How to find list of tables used in stored procedure without “With (nolock)” words [closed]

by


If I understand you correctly, you are looking for all the store procedure names that have the nolock keyword:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%nolock%' 
    AND ROUTINE_TYPE='PROCEDURE'

9

solved How to find list of tables used in stored procedure without “With (nolock)” words [closed]