Re: Get all stored procedures
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Mon, 11 Jul 2005 09:42:36 -0700
Google "BHOM Vaughn"
--
____________________________________
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:46378900-42B1-41F6-AC00-AC41ADB6C303@xxxxxxxxxxxxxxxx
> 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
>>
>>
>>
.
- References:
- Get all stored procedures
- From: David Thielen
- Re: Get all stored procedures
- From: William \(Bill\) Vaughn
- Re: Get all stored procedures
- From: David Thielen
- Get all stored procedures
- Prev by Date: Re: Connection Timeout
- Next by Date: Re: System.Data.SqlClient.SqlException: SQL Server does not exist
- Previous by thread: Re: Get all stored procedures
- Next by thread: RE: Get all stored procedures
- Index(es):
Relevant Pages
|
Loading
