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.