Access to encrypted Scalar Function

When I try to view a scalar function definition I get the following message: "The User Defined Function cannot be scripted as its data is not accessible.  Property TextHeader is not available for UserDefineFunction.  This property may not exist for this object, or may not be retrievable due to insufficient access rights.  The text is encrypted.

Could someone tell me the simplest most benign way to grant myself access rights?
tike55Asked:
Who is Participating?
 
PortletPaulConnect With a Mentor freelancerCommented:
Here is an article on the topic of encrypting and decrypting functions:
https://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

To decrypt you must start with opening a Dedicated Administrator Connection (DAC) to SQL Server; if you can't do that you will not be able to proceed further.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.