ADS Disable encryption using query

[former_member608972]

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?

[jhoehne · Accepted solution]

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