There is another option for a sort of identity column. It's called a Sequence. We recently moved a handful of former system counters to Sequences in MS SQL. Working perfectly.
https://docs.microsoft.com/en-us/sql...ql-server-2017
Also works in Stored Procedures.
I added support like an auto-increment to our sub-class DD class.