You can't -- there is no way to 'un-hide' the text once you've hidden it.
You can only drop and recreate the proc.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Thakur" <sameer1940@gmail.com> wrote in message
news:1137946402.270961.40720@g49g2000cwa.googlegro ups.com...
> hi
>
> I am using ASE 12.5.Somebody fired sp_hidetext in my database.Now I am
> unable to see the hidden procedures. Can u suggest me the best solution
> for this?
>
> sameer
>