Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Identity field corrupt

Anjuna MoonAnjuna Moon Member Posts: 89
I recently discovered that the identity field in one of my tables suddenly has made an enormous leap in its values. The increment and seed are both set to 1 as normal, but suddently the values jumped from 1500 or so, to 402 000 000 and ticking up from there.

I know for certain that no one has hacked into it, cause it's a local database, but what else could possibly cause this.
(SQL Server 7.0)


  • Andre YoungAndre Young USAMember Posts: 0

    ___ / / free ebooks and video tutorials about < PHP, R, JavaScript, Visual Basic, PL/SQL, Scratch, MATLAB, Ruby, Perl, C, Swift, Go, Assembly, C#, Java, Objective-C, C++, Delphi, Visual Basic .NET, Python Prolog, Hack, Lua, COBOL, SAS, Clojure, Ada, D, Julia, Scala, Kotlin, VBScript, FoxPro, ML, Logo, Transact-SQL, Fortran, LabVIEW, Rust, Bash, Alice, Erlang, ABAP, Crystal, Apex, Awk, Lisp, Dart, F#, Scheme /> ___________

Sign In or Register to comment.