title: SQL query to get Stored Procedure crop result if the routine_definition is greater than 4000 char
body: <p>I use this query to get all the stored procedure in my database (I'm using Microsoft SQL Server 2008):</p>
  <pre><code> SELECT
       SPECIFIC_NAME, ROUTINE_DEFINITION
   FROM 
       INFORMATION_SCHEMA.ROUTINES
  </code></pre>
  <p>For almost all result everything is ok, but for the row with a very long <code>ROUTINE_DEFINITION</code> the result is cropped.</p>
  <p>Do you know how to solve it?</p>