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