title: How to find list of tables used in stored procedure with “nolock”?
body: <p>I have more than 1000 Stored procedures, due to some dirty programmers they would have used 'nolock' for stored procedure tables.</p>
  
  <p>Now i am facing lots and lots of issues due to this issue in daily basics.</p>
  
  <p>For some reasons i cant remove all the <code>nolock</code> key words from SP but i need to know in which stored procedure it occurs.</p>
  
  <p>Example:</p>
  
  <p>Let us consider a store-procedure(<code>sp_user</code>) used two tables (<code>tbl_salary</code>) and (<code>tbl_account</code>) and if one table (<code>tbl_account</code>) end with <code>(NOLOCK)</code> then i need to return following details.</p>
  
  <pre><code>**S.N    SP_Name   Table_name**
  
  1      sp_user  tbl_account
  </code></pre>
  
  <p>Any help will me much appreciated... </p>