SQL Server Performance Forum – Threads Archive

Can i retrieve All SProcs that exist in a DB ?

Dear All :: i want to know if there is any way (By Coding )that can help me in retieving All
DataBase’s StoredProcedures Names ?? for example ::
if i use C# i want to Click on Button then in this button code
:: 1 :: connect to required DB
:: 2 :: return All Stored Procedures Names that exist in this DB plz Help me ? http://english.islamway.com

select name from sysobjects where xtype=’p’

SELECT name
FROM sysobjects
WHERE (xtype = ‘p’) will show you all of the stored procedures for the current database. John

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES would be another alternative. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

Have a look at this
http://www.nigelrivett.net/VB/ADOScema.html It makes use of the ado OpenSchema calls to get the data and shouldn’t be restricted to sql server.
Will also get a lot more info about the database. Is in VB but easy to convert.

thanx to aLL my friends http://english.islamway.com

You’re welcome! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

]]>