We need to insert a record into a table (users) whose PK it's NOT 'Identity' enabled;
The problem we are having is that after inserting a second record the account template synchronizes this value into all records which would violate the PK
We need a procedure to achieve the autoincrement without changing the table structure that is without "Identity" enabled