-
I can not delete a record in a SQL server table. I did an insert into the table using VB. I inserted this record 4 times into the Table. I can delete other records in this table but not the ones I inserted in. The error I get is as follows:
Key Column information is insufficient or incorrect. To many rows were affected by update.
I have tried running the SQL Query analizer and used the following code
Delete From tTable
Where AcctNum = "The Account Number"
It returns and says successful but the records are still there????
-
Do you have a primary key on that table?
-
No I do not have a primary key.
-
You don't have to use From clause.
Try something like this:
Delete tTable Where AcctNum = 1
or whatever number you have there.
-
1) try :
select * from tTable insert into ##tempTable Where AcctNum not = "The Account Number"
2) if that works, then:
delete from tTable
3) Followed by:
insert into tTable select * from ##tempTable.
4) If all the above works, get rid of the temp table
drop ##tempTable
You will need to be logged on as sa. Make sure every step works to your liking, before proceding to the next step.
-
I tried both scenerios and it still did not work?????
-
Have your DBA run DBCC on your server, it sounds like there are problems with it.
-
Thanks. I will see what he can do.
-
Add an autonumber primary key to your table. Then delete where primary key = value
-
Thanks Clunietp. I added an Identity number and then I made it the primary key. I then was able to delete them!!!!!!!!!!!!!
