show stored procedure

[Paul]

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

[Hugo Kornelis]

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

--
Hugo Kornelis, SQL Server MVP

[Dirk Van de moortel]

"Hugo Kornelis" <hu**@perFact.REMOVETHIS.info> wrote in message news:ch********************************@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

[Paul]

Thanks Hugo,
thanks Dirk

you helped me a lot!
Paul