sunday630 发表于 2008-10-13 16:14

用户数据库系统表sysstatistics损坏

Checking sysstatistics: Logical pagesize is 4096 bytes
The total number of data pages in this table is 449.
The total number of pages which could be garbage collected to free up some space is 180.
Table has 15935 data rows.
Msg 2510, Level 16, State 2
Key mismatch between index page 14360, at offset 2636 and data page 282 (row ID 27) in database 'BSSCS'. Drop and re-create index id 2 of table 'sysstatistics'.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004   

os:win2003

请教如何处理

chuxu 发表于 2008-10-13 17:10

将数据库置于单用户模式，并sp_configure "allow updates to system tables",1
sp_fixindex dbname,table_name,index_id试试

hobbylu 发表于 2008-10-13 20:59

重新建库吧
页: [1]
查看完整版本: 用户数据库系统表sysstatistics损坏