Post reply

Property TextHeader is not available

  • July 17, 2016 at 8:45 am

    #309205

    Hi,

    When I tried to get the SP script, I got the error "Property TextHeader is not available for StoredProcedure 'xxxxx'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted."

    Any idea?

    Thanks,

  • July 17, 2016 at 11:02 am

    #1890489

    The sp was created with the WITH ENCRYPTION option, if you are lucky someone will tell you where the original script is stored; there may be good reason the WITH ENCRYPTION was used so note any documentation around it.

    Otherwise you can decrypt using a third party tool, or using a DAC connection with a suitable decryption sp, suggest you search for decrypting encrypted procedures, there will be plenty to choose from.

    ...

  • July 18, 2016 at 12:25 am

    #1890523

    Grant VIEW DEFINITION permission to the user

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply