SEO

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

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>

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
>