Thank peterhe,

I want to set combined primary key for 2 columns:TransactionID,TransDate

but when i insert to partition view SQL still raise an error as before.

What can i do to solve that???

Hi, the error description is:

Table error: Object DC_Errors  index  1013331120  Index node page 124452, slot 122345 refers to child page 124535 and previous child 122344, but they were not encountered.

Could u help me or...

thanks for all replies,

Could you mentions more details about two solutions:

1. How to build secondary covered index that match my query

2. Create indexed view to improve performance

can you give me...

Thanks Remi,

but the problem that if i set  tTransToDate to cluster index, i have to set tTransFromDate to cluster index too. My table have many business fields and all of them can...

Hi,

I got my own solution now. all that i need is an string compression function in Vb6. I think it can solve my serious trouble.

Do you know where can i...

Thanks for your advice,

That problem i have to face is occured when workstation need some data from database, such as common list or saved data...

Currently i put all my business...