I have a table with an
int identity as the PK. Something is causing it to increment, and I'd like to know what that is.
To give a quick example, yesterday I inserted a record and got ID 41,773. Today I inserted a new record and I got ID 44,898. There are no records with IDs between these.
There are lots of apps with access to the database, so I'm in the process of checking their logs for errors; however, I'm wondering if there is a way I can find out what queries are causing the IDENTITY increment without a record being inserted.
There are no explicit deletes on this table either, so I know its not an insert + delete combo, causing this, it has to be something failing.