Stored Procedure Text

[Vips]

Hi All,

Can someone please tell me if there is a way to query the Database
(for example SQL Server 2000) and get the text of the stored procedure
that is already existing in the database.

Thanks in Advance,

Vips.

[Herfried K. Wagner [MVP]]

* ku**********@hotmail.com (Vips) scripsit:

Can someone please tell me if there is a way to query the Database
(for example SQL Server 2000) and get the text of the stored procedure
that is already existing in the database.

Group for ADO.NET questions:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Vips]

Thanks Herfried,

I have found a way to query the SQL database for the text within the
Stored Procedure.
Execute the following query:

select routine_definition from information_schema.routines

But i need to the same with all the database like ORACLE, FOXPRO and
MICROSOFT ACCESS.

Can someone please tell me if there is an equivalent way of doing it.

Also Herfried I was not able to understand the link you send me. How
to look for my thread in the link :

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

Thanks in Advance.

cheers,
Vips.


hi***************@gmx.at (Herfried K. Wagner [MVP]) wrote in message news:<bp*************@ID-208219.news.uni-berlin.de>...

* ku**********@hotmail.com (Vips) scripsit:

Can someone please tell me if there is a way to query the Database
(for example SQL Server 2000) and get the text of the stored procedure
that is already existing in the database.

Group for ADO.NET questions:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

[Herfried K. Wagner [MVP]]

* ku**********@hotmail.com (Vips) scripsit:

Also Herfried I was not able to understand the link you send me. How
to look for my thread in the link :

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

It's a link to an other group where you have a better chance to get an
answer. Should only be a little hint.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>