C#/SQL Get all Stored Procedures and their Code

Question

How can I obtain all stored procedures and their code from SQL Server?

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.

Any hints on how to get this information out of SQL Server? P.S., I'm using C#.

Answer 1

SQL Server Management Objects (SMO) would be a good place to start. This article has code examples including listing Stored Procedures:

Getting started with SQL Server Management Objects (SMO)