does anybody knows....

does anyone knows how to get all the stored procedure by using C#
You can query the INFORMATION_SCHEMA.PROCEDURES view to retrieve the names of the stored procedures.
Check out Dave Penton'sINFORMATION_SCHEMA View Examples web page for some code on how to do this in C#.
|||

Hi,
If you run the below statement you wil get the list of stored procedures in that database.

SELECT * FROM SYSOBJECTS WHERE xtype = 'P'

Eralper
http://www.kodyaz.com

|||

eralper wrote:

If you run the below statement you wil get the list of stored procedures in that database.
SELECT * FROM SYSOBJECTS WHERE xtype = 'P'

Directly querying the sys* tables is discouraged by Microsoft as they are not guaranteed to be backwards-compatible. The INFORMATION_SCHEMA views are the recommended approach. See this discussion among a few SQL Server MVPs (including Adam Machanic) on this issue:Use the sys tables or INFORMATION_SCHEMA tables?.