title: Get all stored procedures where table is being used in SQL Server
body: <p>I need the query or code in SQL Server to get all the stored procedures in which table is being used in the server (need all stored procedures in all databases on that server).</p>
  
  <pre><code>SELECT * 
  FROM sys.procedures 
  WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%[dbo].[Batch]%.
  </code></pre>
  
  <p>Above query will give in the current database but I need the query to get from all the databases in that server. </p>
  
  <p>Thanks. Sandeep </p>