Sunday, 30 July 2017

Could not locate statistics in the system catalogs

select top 10 * from [linkedserver].[dbname].dbo.tblauditlog

throw me error:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 2767, Level 16, State 1, Procedure sp_table_statistics2_rowset, Line 105
Could not locate statistics '_WA_Sys_0000001D_6502C82F' in the system catalogs.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

solution:
drop statistics tblauditlog._WA_Sys_0000001D_6502C82F

drop the statistics on primary itworks for me.

its the sql server AG bugs?