theparker

@yitam, I have granted all four database permissions to the user. Still get error when I execute the statement with ColumnEncryption=Enabled. ```sql GRANT VIEW ANY COLUMN MASTER KEY DEFINITION TO...

@yitam, I understand the [EXCEPT operator](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql) can be used in your example, however, you are restricted by the number of columns you can list using the EXCEPT operator (for instance,...

Thanks for the reply @yitam. We use subqueries throughout our application but only few queries include encrypted columns. Barely any of our queries reference encrypted columns in subqueries.

@yitam that sounds like the way to go though there could be issues when running queries in a transaction across multiple connections but I guess we will cross that bridge...