Solved

Sql server is not committing row

Posted on 2014-10-29
8
412 Views
Last Modified: 2014-11-13
Hi.
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.
0
Comment
Question by:Deraldo Silva
  • 4
  • 4
8 Comments
 
LVL 32

Expert Comment

by:Stefan Hoffmann
Comment Utility
So, what kind of front-end are you using?
0
 

Author Comment

by:Deraldo Silva
Comment Utility
Sorry.

Microsoft SQL Server Management Studio                                    11.0.5058.0
Microsoft Data Access Components (MDAC)                                    6.3.9600.16384
Microsoft MSXML                                    3.0 4.0 6.0
Microsoft Internet Explorer                                    9.11.9600.17351
Microsoft .NET Framework                                    4.0.30319.34209
Operating System                                    6.3.9600
0
 
LVL 32

Expert Comment

by:Stefan Hoffmann
Comment Utility
So you're working in SSMS? Then post a concise and complete example. A screenshot would also be interesting.
0
 

Author Comment

by:Deraldo Silva
Comment Utility
Ok. attached
problem.pdf
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 32

Expert Comment

by:Stefan Hoffmann
Comment Utility
Well, just press the ! button - Query Designer\Execute SQL (Ctrl+R). The edit grid has some limitations.
0
 

Author Comment

by:Deraldo Silva
Comment Utility
yep. I already did it. BUT, when I do that, the record goes away.
0
 
LVL 32

Accepted Solution

by:
Stefan Hoffmann earned 500 total points
Comment Utility
So, then use a query to do your update or insert. The grid hiddes the real cause.

btw, sure that there are no triggers on those tables?
0
 

Author Comment

by:Deraldo Silva
Comment Utility
no. there are no triggers.
so, I remove all records and recreate them. it is ok now.
thx
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now