can't delete records or rows from SQL Server

[pnj]

I have a table that is not connected in any way to any other tables.
it has 5 fields of character type invarchar and int

i can't delete or add records to it. I was able to add a few but now when I try I get an error message saying

Key column information is insufficient or incorrect. Too many rows were affected by update.

what?

I tried to create a new table, thinking i could just delete the first one but i get the same error message....

[vb_dba]

Add a unique index on the table. If each row is not unique, then your table is not normalized and you need to rethink your design.

CREATE UNIQUE
INDEX index_name ON table (column [,...n])

[pnj]

do you mean something like an auto incrementing row?

or a primary key?

I'm trying that right now....

[vb_dba]

Yes, a primary key is what I'm talking about. If you can create one using the columns already in your table, then I would suggest doing that before adding an Identity column to your table, as it can be flaky sometimes (or so I hear).

[pnj]

i ended up just re-upsizeing it from access.

i couldn't the primary key the way i thought i should.

or rather, i couldn't add the relationships i needed to.

so i did it in access and re-upsized it. it works fine now.


that's why i was asking about saving sprocs in the other post.

thanks again.

[Lord_Rat]

Sometimes, our identity columns will break and we get the same error you just described (and in rare cases, the data starts duplicating itself).

In these cases, we usually drop the identity column and recreate it.

You may not have this as an option, however, if the identity column is your relational column.