Ok I have a development SQL server table that I have been running tests on it and adding a bunch of junk rows to the table. I thought I could delete the junk rows out easy enough since I have done that in Access before but I just made a huge mess.
What I did was:
Using the management studio interface, in design mode for the table I
1. Removed the primary key constraint, changed the identity specification for the Identity column and removed its' Identity=Yes.
2. Then I edited the table rows and deleted the extra rows and "recordered" the primary key and identity column to start over with 1, 2, 3 extra with the remaining good rows.
3. Then I went back into design mode and made the identity column an identity with seed and readded the primary key.
However, now when I tried to add a new row it is giving me all sorts of errors. First,
It was giving me this error: Go to the complete details ...