Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
Configuration group |
|
Set enable encrypted columns to 1 (on) to use the encryption functionality.The option is turned off in a server that has the liscense to use encrypted columns. any commands against encrypted columns fail with an error. You must set both the configuration parameter and the license option to enable encryption.
sp_configure 'enable encrypted columns', 1 go
Adaptive Server 15.0.2 changes enable encrypted columns from static to dynamic. In other words, you do not need to restart Adaptive Server for the parameter to take effect.
