title: C#/SQL Get all Stored Procedures and their Code
body: <p>How can I obtain all stored procedures and their code from SQL Server?</p>
  
  <p>I need to show data that is similar to what SQL Server Management Studio shows, incl. allowing to browse through SP's with code, tables and indexes. </p>
  
  <p>Any hints on how to get this information out of SQL Server? P.S., I'm using C#.</p>