We don't *need* the data to be stored in tempdb per se, it is just that we select into #tmp tables...
We have many large tables in our database and we noticed...

Thank you, Steve!
Is this a limitation that was introduced on purpose, when copying encrypted data between a regular DB and tempdb (or any other database)?
Because if i'm trying...

Hi Steve (sgmunson),
I created the 2 initial keys directly on the TEST_AE database, through MS SSMS, then encrypted the PlaceOfBirth field in the G_CONTACTS table.
Then, scripted out the...

Hi Steve - Thanks for the quick reply!
I'm trying to store data into a #tmp table, and even this is not really working... Our first target is to be...

Hi Steve,
What would be your approach if you absolutely HAD TO implement Always Encrypted columns in an SQL environment which uses many #temp tables?
I have such a context...