Tuesday, 21 November 2017
AUSQLUG Forums Home   Search   Login   Register   Member List  
SQL Server 2000 Forums  > Reporting Services  > low identity value inserted  
Display using:  
Previous Thread :: Next Thread 
 Author Thread: low identity value inserted
RyanCaleb is not online. Last active: 8/11/2017 11:20:51 PM RyanCaleb
Top 25 Poster
Joined: 13 Sep 2017
Total Posts: 66
low identity value inserted
Posted: 16 Oct 2017 10:00 PM
I have a table that has an identity on it. There are many people and apps that hit this table. the value increments as normal most of the time, but every now and then, we get a low value, as if someone uses and identity insert or reseeds it and it causes issues. So, I'm trying to find out the user that may be doing it. I set up a trigger (this is a non-prod env) to log if a new value is used lower than the max value and it logs to a staging type table. I got a hit and asked the user what they were doing. they just did a manual insert of a couple of rows, no reseed or identity insert. a record was inserted normally and then a day later, this user inserted a record with the low value, so this doesn't tell me he did it, but rather that something happened from the last insert until his insert.

I didn't find the right solution from the Internet.

References https://www.sqlservercentral.com/Forums/1861606/low-identity-value-inserted

3d product teaser
Previous Thread :: Next Thread 
Page 1 of 1
AUSQLUG Forums  > SQL Server 2000 Forums  > Reporting Services  > low identity value inserted