How to unhide/read SQL TEXT of SP

[Former Member]

Hello Everyone,

Please lemme know the procedure to unhide / view the SQL text of stored procedure which is in hidden state .

I have sa login to access the server and I can dump sybsystemprocs and I can load in another other if required to view the SQL text.

Thanks in advance .

[hans-juergen_schwindke]

Hi,

it is not possible to unhide the SQL text with a command.

There are some possibilities (read deleted data or open a TechSupport ticket) that have been discussed in this thread:

Best regards,

Juergen