Skip to Content
0

ADS Disable encryption using query

Jan 10, 2017 at 03:49 PM

86

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joachim Höhne Jan 10, 2017 at 04:30 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded