Hi Paul

Theirs the message when I run the script.

Server: Msg 8951, Level 16, State 1, Line 1

Table error: Table 'cicmpy' (ID 105767434). Missing or invalid key in index 'ix_debcode' (ID 35) for the row:

Server: Msg 8955, Level 16, State 1, Line 1

Data row (1:17392:1) identified by (RID = (1:17392:1) cmp_wwn = 5A3C5B0F-D651-4098-B2A3-86BF317C2309È™Ú) has index values (debcode = ' 2008088300354' and debnr = ' 2859' and cmp_wwn = 5A3C5B0F-D651-4098-B2A3-86BF317C2309P¢Ú).

Server: Msg 8951, Level 16, State 1, Line 1

Table error: Table 'cicmpy' (ID 105767434). Missing or invalid key in index 'ix_timestamp' (ID 37) for the row:

Server: Msg 8955, Level 16, State 1, Line 1

Data row (1:17392:1) identified by (RID = (1:17392:1) cmp_wwn = 5A3C5B0F-D651-4098-B2A3-86BF317C2309È™Ú) has index values (timestamp = and Administration = '883' and cmp_type = 'C' and cmp_wwn = 5A3C5B0F-D651-4098-B2A3-86BF317C2309P¢Ú).

Server: Msg 8929, Level 16, State 1, Line 1

Object ID 948198428: Errors found in text ID 188394831872 owned by data record identified by RID = (1:124888:8) ID = F9479DFA-F531-4ED4-8BBF-CABF88860B26üÕÚ.

Server: Msg 8929, Level 16, State 1, Line 1

Object ID 948198428: Errors found in text ID 185351864320 owned by data record identified by RID = (1:169747:2) ID = E8C94033-ADAF-4D3F-A0FE-5ED688476E68üÕÚ.

Server: Msg 8961, Level 16, State 1, Line 1

Table error: Object ID 948198428. The text, ntext, or image node at page (1:56400), slot 3, text ID 188394831872 does not match its reference from page (1:169747), slot 2.

Server: Msg 8974, Level 16, State 1, Line 1

Text node referenced by more than one node. Object ID 948198428, text, ntext, or image node page (1:56400), slot 3, text ID 188394831872 is pointed to by page (1:169747), slot 2 and by page (1:124888), slot 8.

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 948198428. The text, ntext, or image node at page (1:436570), slot 1, text ID 185351864320 is not referenced.

CHECKDB found 0 allocation errors and 2 consistency errors in table 'cicmpy' (object ID 105767434).

CHECKDB found 0 allocation errors and 5 consistency errors in table 'BacoDiscussions' (object ID 948198428).

Server: Msg 8935, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 1. The previous link (1:168520) on page (1:171608) does not match the previous page (1:436528) that the parent (1:6401), slot 20 expects for this page.

Server: Msg 8936, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 1. B-tree chain linkage mismatch. (1:436528)->next = (1:171608), but (1:171608)->Prev = (1:168520).

Server: Msg 8934, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 1. The high key value on page (1:436528) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:171608).

Server: Msg 8934, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 2. The high key value on page (1:6927) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:436536).

Server: Msg 8935, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 2. The previous link (1:436536) on page (1:8199) does not match the previous page (1:6927) that the parent (1:4810), slot 119 expects for this page.

Server: Msg 8977, Level 16, State 1, Line 1

Table error: Object ID 1339151816, index ID 2. Parent node for page (1:436536) was not encountered.

CHECKDB found 0 allocation errors and 6 consistency errors in table 'Addresses' (object ID 1339151816).

CHECKDB found 0 allocation errors and 13 consistency errors in database '883'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (883 ).

Thanks

Vincent