Sql server is not committing row
Posted on 2014-10-29
I have three tables. Customers with PersonID as identity PK and Functionalities with FunctionalityID as identity PK.
Between them, I have a N:M table with these both keys, as group key.
well, some records, not all, that I try to insert it mannually (with the stored procedure is the same), I got the error:
"This row was successfully committed to the database. However, a problem occurred when attempting to retrieve the data back after the commit. Because of this, the data in this row is read-only. To fix this problem, please re-run the query."
what is wrong? why only some records?
thx in advance.