Posted by Dirk Van de moortel on 01/11/06 22:17

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info> wrote in message news:chnas11g2ihp2f1fldv0h9fi8fogfavu8t@4ax.com...
> On Wed, 11 Jan 2006 18:32:07 GMT, Paul wrote:
>
> >Hello,
> >
> >I only have remote access to the db via textual interface.
> >
> >Now I try to find out what an existing stored procedure is doing.
> >I tried like 'desc sp_sale_pro' and 'show sp_sale_pro' - but that is not
> >working.
> >
> >Can anybody help?
> >
> >Thanks!!
> >Paul
>
> Hi Paul,
>
> sp_helptext sp_sale_pro

Ha, that's good to know :-)
I always used the little select that I just posted, packaged
in another stored procedure. That means I can get rid of it
now.

Thanks,
Dirk Vdm

[Back to original message]