Object ID 933578364, index ID 0: Page (1:7254) could not be processed. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Object ID 933578364, index ID 0: Page (1:7160) could not be processed. Second table: Msg 8928, Level 16, State 1, Line 1 Row error: Object ID 578101100, index ID 0, page ID (1:24157), row ID 61.Ĭolumn 'wh_id' was created NOT NULL, but is NULL in the row. I ran DBCC CHECKDB on the database and I got 6 consistency errors in two tables, for the first table: Msg 8970, Level 16, State 1, Line 1 Mostly overflow errors, sometimes in SqlDateTime and sometimes in data type numeric.įor example, right now I have a column with 1099511628.776 as its value, the column type is decimal(18,3) which can hold up to 10^38, so clearly this is not an overflow, however when I try to update that column and set it to 1 I get the error Arithmetic overflow error converting numeric to data type I have SQL Server 2000 and ever since upgrading from SP2 to SP4 random errors began happening.
0 Comments
Leave a Reply. |