• Thanks for your reply:

    When checking Database with

    DBCC CHECKDB()......

    I got many error lines. First few lines are:

    "Msg 8952, Level 16, State 1, Line 1

    Table error: Database 'FOR11213', index 'sysobjects.ncsysobjects' (ID 1) (index ID 2). Extra or invalid key for the keys:

    Msg 8956, Level 16, State 1, Line 1

    Index row (1:186:32) with values (name = 'NSD34949300' and uid = 1 and id = 1652942452) points to the data row identified by ().

    CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysobjects' (object ID 1).

    Msg 8951, Level 16, State 1, Line 1

    Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

    Msg 8955, Level 16, State 1, Line 1

    Data row (1:28568:0) identified by (RID = (1:28568:0) id = 1652942452 and colid = 17 and number = 0) has index values (id = 1652942452 and name = 'Brand_ID' and number = 0 and id = 1652942452 and colid = 17 and number = 0).

    Msg 8951, Level 16, State 1, Line 1

    Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

    Msg 8955, Level 16, State 1, Line 1

    Data row (1:28568:1) identified by (RID = (1:28568:1) id = 1652942452 and colid = 18 and number = 0) has index values (id = 1652942452 and name = 'Order_Convert_Price' and number = 0 and id = 1652942452 and colid = 18 and number = 0).

    Msg 8951, Level 16, State 1, Line 1

    Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

    Msg 8955, Level 16, State 1, Line 1

    Data row (1:28568:2) identified by (RID = (1:28568:2) id = 1652942452 and colid = 19 and number = 0) has index values (id = 1652942452 and name = 'Sr_No' and number = 0 and id = 1652942452 and colid = 19 and number = 0).

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'syscolumns' (object ID 3)."

    Thanks and bet regards

    NayMin