My customer asks to put NOLOCK statement in ALL SPs which has SELECT satement.
INNER JOIN [test]
I need to identify the such SPs and replace with nolock
FROM [dbo].[table] (nolock)
INNER JOIN [test] (nolock)
I've 500 SPs in my application. How to achive it easily.. I hope using regex we could do that. Please guide me how to achieve it?