Re: Get all stored procedures
- From: "David Thielen" <thielen@xxxxxxxxxxxxx>
- Date: Sun, 10 Jul 2005 18:09:02 -0700
Hello;
Does anyone know the specific select for Sql Server and/or Oracle to get the
stored procedures?
Any any idea how to get it from the OLE-DB connector
--
thanks - dave
ps - what is BHOM?
"William (Bill) Vaughn" wrote:
> Two of the data sources you mention have different interfaces and different
> ways to expose stored procedures--OLE DB is simply an interface to data
> sources.
> For SQL Server, you can use the sysobjects table to query for all objects in
> the database. For Oracle? BHOM.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message
> news:6430337F-0929-4A78-94C3-5A58CBE5A43F@xxxxxxxxxxxxxxxx
> > Hi;
> >
> > Is there a way under ADO .NET to get all stored procedures in a database.
> > I'd prefer a single solution but I can live with one that is specific to
> > each
> > driver: Sql Server, Oracle, and OLE-DB.
> >
> > --
> > thanks - dave
>
>
>
.
- Follow-Ups:
- Re: Get all stored procedures
- From: William \(Bill\) Vaughn
- Re: Get all stored procedures
- From: Steven Cheng[MSFT]
- Re: Get all stored procedures
- References:
- Get all stored procedures
- From: David Thielen
- Re: Get all stored procedures
- From: William \(Bill\) Vaughn
- Get all stored procedures
- Prev by Date: SqlParameterCollection Reuse- App architecture decision
- Next by Date: Re: Connection Timeout
- Previous by thread: Re: Get all stored procedures
- Next by thread: Re: Get all stored procedures
- Index(es):
Relevant Pages
|
