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?
-
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