Is it possible to get the definition of a Stored Procedure using the name (without having to look in the object explorer)
<p>I'm working on a database that has an huge number of stored procedures. The frustrating part is that the naming convention is not consistent. I spent half of my time looking for them in the <strong>object explorer</strong>.</p>

<p>I'd like to know whether there's a way to get the <strong>definition of a SPROC</strong> just by knowing the name? Something like:</p>

<pre><code>SELECT commande(name_of_SPROC) --&gt; Display the definition of the SPROC
</code></pre>

<p>Just anything that can help me get the definition of a SPROC without having to search in the Object explorer of the <strong>SQL Server Management Studio</strong>.</p>

<p>Thanks for helping</p>