title: How to find stored procedures by name?
body: <p>I just need to search through all the stored procedures on my database looking for one that contains "item" in its name. Any ideas?</p>
  
  <p>I've been tinkering around with this, but it's not quite there yet:</p>
  
  <pre><code>SELECT DISTINCT OBJECT_NAME(ID) FROM SysComments WHERE Text LIKE '%Item%'
  </code></pre>