Skip to Content
avatar image
Former Member

How to unhide/read SQL TEXT of SP

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 .

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 12, 2016 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2016 at 01:03 PM

    If you're referring to undoing the results of running sp_hidetext ... you can't. See this post - sp_hidetext hid everything!! | SCN - for a further discussion.

    Add comment
    10|10000 characters needed characters exceeded