Monday, October 31, 2011

Sql Server script failed for storedProcedure property TextHeader is not available for storedProcedure. This property may not exists for this object, or may not be retrievable due insufficient access rights. The text is encrypted

PROBLEM:
When trying to open stored procedure or other object with Sql Server Management Studio you get the error "Sql Server script failed for storedProcedure property TextHeader is not available for storedProcedure. This property may not exists for this object, or may not be retrievable due insufficient access rights. The text is encrypted"
You are trying to do that by right click on the stored procedure -> "Script Stored Procedure as" -> "CREATE To" -> "New Query Editor Window"

SOLUTION:
The stored procedure is not encrypted, the error is because there is no grant permission "VIEW DEFINITION"

Right click on the database -> properties -> permissions. Choose the relevant users or roles, go to the bottom of the permissions "Explicit " tab. There you can see the "View definition" permission. You should grant it.



If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


23 comments:

  1. Getting same error. Not working for me

    ReplyDelete
  2. Thanks for sharing, nice post! Post really provice useful information!

    An Thái Sơn với website anthaison.vn chuyên sản phẩm máy đưa võng hay máy đưa võng tự động tốt cho bé là địa chỉ bán máy đưa võng giá rẻ tại TP.HCM và giúp bạn tìm máy đưa võng loại nào tốt hiện nay.

    ReplyDelete
  3. Sometimes it’s related to your SSMS version..

    ReplyDelete