MSSQL database table DATE field has corruption. The error message says it is at row 169441. I cannot finish an export, browse to the record or delete it. I got the bad record below by exporting to a text file and this was the last record before it stopped.
This is the bad record. 2nd field is DATE
"0000000004015 ",15955-04-30 103:21:55.207000000,"
This is a good record immediately preceding the bad one.
"0000000004015 ",2006-01-22 00:00:00,"
Set RowCount 169440 -- Process only first nnnn rows.
Select * Into #TMP_Table from YourTable
Set RowCount 169441 -- Process only first nnnn rows.
Delete From YourTable -- Should delete all rows copied plus the bad one.
Set RowCount 0 -- Process all rows
Insert Into @TMP_Table Select * From YourTable -- Copy the rest
This is a big "??". The "Select"s and "Delete"s may not process all rows in the same order, but they probably will. If nothing else works it is worth a try. Just make sure that you can restore from your backup!
You could try some of the undocumented DBCC commands to force the data.