Re: Get all stored procedures
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Sun, 10 Jul 2005 11:55:02 -0700
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: David Thielen
- Re: Get all stored procedures
- References:
- Get all stored procedures
- From: David Thielen
- Get all stored procedures
- Prev by Date: Re: System.Data.SqlClient.SqlException: SQL Server does not exist
- Next by Date: Login problem: MSDE from ASP.Net
- Previous by thread: Get all stored procedures
- Next by thread: Re: Get all stored procedures
- Index(es):
Relevant Pages
|
