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?
Request clarification before answering.
There is a function called "sp_SetDDEncryptionType" that should do the trick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.