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:
select diagram from Mytable where id = 5
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,