Concurrency error when deleteing or updating multiple primary key fields
11-May-2020 14:33
I ended up coding some brief tests to confirm how SQL 2016 (EXPRESS) behaves - and thought it would be appropriate to share as it might help others searching for similar information.
Nested triggers are limited to 32 levels, and default to 1.This is confirgured via the sp_configure stored proceedure, where you can turn recursive or nested triggers on or off.