ID increment problem (Sql Server 2012)

  • Good morning,

    I don't understand what's going on in my database

    all tables that have an auto-increment ID will stop auto-incrementing. and I have a message that the code exists.

    and to overcome this problem I have to delete the ID of the table and I recreate it so that it works

     

    Cordially

  • Are you using identities or sequences to auto-increment the IDs?

    did someone RESEED your identity values ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Alaoui Mohamed Moctar wrote:

    Good morning, I don't understand what's going on in my database all tables that have an auto-increment ID will stop auto-incrementing. and I have a message that the code exists. and to overcome this problem I have to delete the ID of the table and I recreate it so that it works

    Cordially

    What is the exact text of the error message?

    Which operation causes the error ... an INSERT, or something else?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • In fact I think one of the administrators performed a task that should not do with the RESEED command

    Thanks for everyone

     

    SOLVED

  • This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply