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

by

[ad_1]

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

[ad_2]

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