Server提供的统计信息流已损坏

Question

我正在尝试将统计数据添加到我已经创建的表中。当我试图运行它时，它抛出一个错误：

提供的统计信息流已损坏。

这是我对一个统计数据示例的查询：

IF NOT EXISTS (SELECT * 
               FROM sys.stats 
               WHERE name = N'_WA_Sys_00000027_3C69FB99' 
                 AND object_id = object_id(N'[dbo].[PromotionEvent]'))
    CREATE STATISTICS [_WA_Sys_00000027_3C69FB99] 
        ON [dbo].[PromotionEvent]([CRMCode]) 
        WITH STATS_STREAM = 0x010000000100000000000000000000008B95918100000000C4040000000000008404000000000000E7020000E7000000480000000000000008D0000090D4B94007000000AB7FBA0034A60000BA29000000000000BA290000000000000000803FD9899D3D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B0000000B0000000100000010000000ACB7283D00E8264600E02446ACB7283D000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013000000000000000000000000000000E1020000000000001003000000000000180300000000000058000000000000006B00000000000000AA00000000000000E90000000000000028010000000000006701000000000000A601000000000000E50100000000000024020000000000006302000000000000A202000000000000100010000000EE42000000000000803F040000300010000000803F0000803F0000803F04000001003F00320046003200300043003100350037002D0034003500330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00330036003300380043003300300039002D0033003500330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00330046003600350039003300440044002D0030003400330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00350045003000320030003800460044002D0034004200330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00380045003400370044003100310045002D0034003000330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00410030003100310033003100330039002D0034004500330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00410045003400460037004200440046002D0033003100330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00430041003300360044003000340031002D0038003700330043002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00430045003600410039003200320042002D0034003700330044002D0045003600310031002D003800300010000000803F000000000000803F04000001003F00450044004500340043003300310039002D0034003800330044002D0045003600310031002D003800FF010000001A0200002002000002000000280000002800000000000000000000000000000001000000060000000000BA29000000000000
GO

为什么我会有这个错误？是不是因为小溪太长了？我该怎么解决这个问题？我必须坚持这个流，因为我正在进行数据归档，所以统计数据必须有类似的名称。

谢谢

Answer 1

尝试对您的DB运行DBCC，看起来您已经损坏了ID为60的系统表，其中包含有关DB中对象的信息。

吉洛莫拉

Answer 2

试着使用

DBCC (YourTableName，REPAIR_REBUILD )

在执行上述操作时，请确保数据库处于单一用户模式。

如果这不起作用，那么您可以尝试删除表的主键并重新创建它.

此外，如果问题仍未得到解决，最后一种选择是：

DBCC (YourTableName，REPAIR_ALLOW_DATA_LOSS)