Stored Procedure Text

  • Thread starter Thread starter Vips
  • Start date Start date
V

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.
 
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/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

Thanks in Advance.

cheers,
Vips.
 
Back
Top