Tuesday, March 20, 2012

Primary key constraint error

We have an SQL Server database that has one damaged data row. The row can't
been updated and if it has been removed and added again with the same primary
key, the row won't still work.
When we try to modify the row, we get on error:
'Another user har modified the contents of this table or view; the database
row you are modifying no longer exists in the database.'
We have installed the SQL Server SP4.
Is there a way fix the table?
BR
Johanna Turku
Hi
Do you modify it by using EM?
"Sebitti" <sebittionline@.companysebitti.fi> wrote in message
news:A70D025E-B2F6-49E2-B9FA-568E3D7750AE@.microsoft.com...
> We have an SQL Server database that has one damaged data row. The row
> can't
> been updated and if it has been removed and added again with the same
> primary
> key, the row won't still work.
> When we try to modify the row, we get on error:
> 'Another user har modified the contents of this table or view; the
> database
> row you are modifying no longer exists in the database.'
> We have installed the SQL Server SP4.
> Is there a way fix the table?
> BR
> Johanna Turku
|||Yes, I try to it by using EM, query analyzer and ado. None of them worked.
"Uri Dimant" wrote:

> Hi
> Do you modify it by using EM?
> "Sebitti" <sebittionline@.companysebitti.fi> wrote in message
> news:A70D025E-B2F6-49E2-B9FA-568E3D7750AE@.microsoft.com...
>
>

No comments:

Post a Comment