Can i retrieve All SProcs that exist in a DB ? | SQL Server Performance Forums

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 ?
select name from sysobjects where xtype=’p’
FROM sysobjects
WHERE (xtype = ‘p’) will show you all of the stored procedures for the current database. John

FROM INFORMATION_SCHEMA.ROUTINES would be another alternative. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterstuetze PASS Deutschland e.V.
Have a look at this 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
You’re welcome! [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Heute schon gebloggt?<a target="_blank" href=></a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=></a>)