Error: Can't delete row or update row in SQL Server ?
-
Hi everyone, I am creating a query to my database using SQL Server Management Studio There is a data error in my image field of my row. I still can select another fields, but when I select content of the image field I get below error: My query:
select diagram from Mytable where id = 5
Error 1: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) When I tried to delete this row. I got another error (Error 2): SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4da7af2c; actual: 0xda5e9af7). It occurred during a read of page (1:40403) in database ID 6 at offset 0x00000013ba6000 in file 'D:\CLCData\23_01_2013\CLC_LIS_Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. When I select all data from the table, I got the error 1 at the above row position. So, now I can't update or delete this row. Do you know this problem and how to fix it ? Thank you very much, Tai
-
Hi everyone, I am creating a query to my database using SQL Server Management Studio There is a data error in my image field of my row. I still can select another fields, but when I select content of the image field I get below error: My query:
select diagram from Mytable where id = 5
Error 1: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) When I tried to delete this row. I got another error (Error 2): SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4da7af2c; actual: 0xda5e9af7). It occurred during a read of page (1:40403) in database ID 6 at offset 0x00000013ba6000 in file 'D:\CLCData\23_01_2013\CLC_LIS_Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. When I select all data from the table, I got the error 1 at the above row position. So, now I can't update or delete this row. Do you know this problem and how to fix it ? Thank you very much, Tai
Have you done what the error message suggested?
Never underestimate the power of human stupidity RAH
-
Have you done what the error message suggested?
Never underestimate the power of human stupidity RAH
Hi, I checked the log error file. For the select query, I got the below error: Error: 7886, Severity: 20, State: 1. 2014-07-14 11:27:01.50 spid52 A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated. For the delete statement, I got the message: Error: 824, Severity: 24, State: 2. 2014-07-14 13:34:10.12 spid51 SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4da7af2c; actual: 0xda5e9af7). It occurred during a read of page (1:40403) in database ID 6 at offset 0x00000013ba6000 in file 'D:\CLCData\23_01_2013\CLC_LIS_Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online But, I don't know how to fix it.
-
Hi, I checked the log error file. For the select query, I got the below error: Error: 7886, Severity: 20, State: 1. 2014-07-14 11:27:01.50 spid52 A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated. For the delete statement, I got the message: Error: 824, Severity: 24, State: 2. 2014-07-14 13:34:10.12 spid51 SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4da7af2c; actual: 0xda5e9af7). It occurred during a read of page (1:40403) in database ID 6 at offset 0x00000013ba6000 in file 'D:\CLCData\23_01_2013\CLC_LIS_Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online But, I don't know how to fix it.
:sigh: Execute DBCC CHECKDB int SQL Server Management Studio, just like the error message tells you, then see what the results of the check are.
Never underestimate the power of human stupidity RAH
-
Hi everyone, I am creating a query to my database using SQL Server Management Studio There is a data error in my image field of my row. I still can select another fields, but when I select content of the image field I get below error: My query:
select diagram from Mytable where id = 5
Error 1: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) When I tried to delete this row. I got another error (Error 2): SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4da7af2c; actual: 0xda5e9af7). It occurred during a read of page (1:40403) in database ID 6 at offset 0x00000013ba6000 in file 'D:\CLCData\23_01_2013\CLC_LIS_Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. When I select all data from the table, I got the error 1 at the above row position. So, now I can't update or delete this row. Do you know this problem and how to fix it ? Thank you very much, Tai