title: Find Stored Procedure that Inserts Into a Specific Table
body: <p>Is there a way to find what stored procedures create an entry in a table. Say for example:</p>
  
  <p>Stored Procedure A inserts into Table A<br>
  Stored Proceudre B Inserts into Table A<br>
  Stored Procedure C Inserts into Table B<br></p>
  
  <p>I want to the query to return the name of Stored Procedure A and Stored Procedure B.</p>
  
  <p>Ive got this right now, but all it does is find Stored Procedures. I think it would be a good starting point to find the stored procedures.</p>
  
  <pre>
  <code>
  select schema_name(schema_id) as [schema], 
         name
  from sys.procedures
  where name like '%Item%' and name like '%Create%'
  </code>
  </pre>
  
  <p>I am using Microsoft SQL 2008</p>