We are applying Always encrypted(AE) related to changes to stored procs. Suppose one such stored proc calls another 20 SPs. Each of those 20 SPs call another 5, and so on. Some of these SPs are decade old.
Should all the stored procs needs to be recompiled which are being called in that nested fashion, irrespective of whether the encrypted params are being passed to all of them or not?
The SP works fine without the AE changes, but starts giving weird errors with AE changes. AE changes are small changes with none-or-little logic changes.
I couldn't find any documentation about this.
