Find string inside a stored procedure
<p>I need to search for a string inside a stored procedure. This is created by user. So I <strong>cannot</strong> use this:      </p>

<pre><code>SELECT OBJECT_NAME(object_id), AS MYSPDEFINITION
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%string%';
</code></pre>

<p>I have a column which has stored procedures, example: "<code>execute salarybyid</code>" and so on, in each and every row up to 200. How to find if these stored procedures have a specific string in them?</p>