You are here: Re: show stored procedure « MsSQL Server « IT news, forums, messages
Re: show stored procedure

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация