cancel
Showing results for 
Search instead for 
Did you mean: 

ADS Disable encryption using query

01-10-2017 4:49 PM
665 views 1 comments Go to solution
0 Likes
SAP Managed Tags
Subscribe

I tried using encryption on all my Data Dictionaries, but I no longer need the encryption, so I tried to disable it using queries ( doing it manually would cost me hours because of the amount of tables/ data dictionary files ).

I'm able to disable the encryption on tables,indexes and the communication using SP_ModifyDatabase, but I can't seem to find how to disable the encryption on the Data Dictionary file itself?

Is there a way to do this using queries?

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

jhoehne
Participant

There is a function called "sp_SetDDEncryptionType" that should do the trick

Answers (0)