I have a 2008 database / classic asp portal. It has a column for name, email, and username.
According to the GDPR and upcoming CCPA privacy regulations, some or all of these fields may need to be encrypted.
There are hundreds of thousands of lines of code that refer to these un-encrypted columns.
Does MS SQL have a method to encrypt a column and have any code running with Windows authentication see the data without having to rewrite the stored procs and/or server-side scripting?
I hope so anyway.