Thakur wrote:
> 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

>From the ASE reference manual (although I've found plenty of
inaccuracies in) :

<snip>
sp_hidetext hides the source text for the specified compiled object.
Warning!
Before executing sp_hidetext, make sure you have a backup of the source
text. The results of executing sp_hidetext are not reversible.
If you do not provide any parameters, sp_hidetext hides the source text
for all compiled objects in the current database.
</snip>