After restarting the server, I cannot execute requests for data that was recorded today.

For example:

SELECT TOP 1000 * FROM table WHERE date = '20170816' -- вчерашняя дата

Works fine

 SELECT TOP 1000 * FROM table WHERE date = '20170817' -- сегодняшняя дата

Gives an error message

Сообщение 601, уровень 12, состояние 3, строка 1 Не удалось продолжить просмотр с NOLOCK вследствие перемещения данных

date datetime field type date datetime

I can not understand what could be a mistake and where to start.

  • Attach the text of the error. - Denis
  • And at the same time the structure of the table (at least the type of the date field). - Akina
  • one
    I think the table is broken. Try to make repair by regular means. - tcpack4
  • I made dbcc checktable and rebuilt the indexes in the tables where errors occurred and checked if the error went away, if not, did repair_rebuild . But after that, some data got off and had to manually correct incorrect data. - Urma

0