title: SQL- Count occurrences of a specific word within all stored procedures
body: <p>I need to count the occurrences of a particular word in all of my stored procedures.</p>
  
  <p>i.e. How many times does the word 'place' occur in all of the stored procedures within a specific database?</p>
  
  <p>I was trying to do this using cursors, but I am not getting anywhere!</p>