Skip to Content
avatar image
Former Member

ADS Disable encryption using query

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 10, 2017 at 04:30 PM

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

    Add comment
    10|10000 characters needed characters exceeded