We have been using ApexSQL Triggers for years without any issues. We would like to actually have Insert/Update/Delete triggers on a field that is encrypted using MS "Always Encrypted". If we simply add that field to the our list of fields to build triggers for, generate the Trigger Build script and then try executeing that in an SSMS Query, it fails with the "Explicit conversion from data type varchar(50) encrypted with (encryption_type = 'DETERMINISTIC', ..." type message. We don't want the data to be "decrypted" as its written to the Audit tables, we'll do that on the backend when querying. But we would like to know the data was touched, when and by whom. Is it possible to do such a thing with the Triggers product?
Thanks in advance.
