create procedure usp_demo
as
-- Secret comment
return 0
go

sp_hidetext usp_demo
go

sp_helptext usp_demo
go
Msg 18406, Level 16, State 1:
Server 'AFRIN', Procedure 'sp_helptext', Line 358:
Source text for compiled object usp_demo (id = 553049975) is hidden.
(return status = 1)

C:\Sybase\ASE-15_0\bin\diagsrvr.exe -s<SERVERNAME>
...

create table #x (id int)
insert into #x values (object_id('usp_demo'))
dbcc _unhide_text('#x')
go

sp_helptext usp_demo
go
 # Lines of Text
 ---------------
               1

(1 row affected)
 text

create procedure usp_demo
as
-- Secret comment
return 0

(1 row affected)