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