Hi, this works - I 'forced' one of the over deveopers to test it.

Hopefully there will be a patch out soon..

dan

lol, luckerly it's unqueid so that wont go in..

dan

Hi, yes have run dbcc checktable, no errors reported.

We have one clustered index on a date field, and then one normal index on the id.

One of our guys created another...

Well we've found out that it's the index's that's causing the problem.

Dono why or how.. I think were going to rebuild the whole database over the weekend to try to...

Hi, this is starting to really do our heads in , we've droped the table and recorated.

Recreated the indexes, just about everything we can think of.

Doing the qureies doent...

Hi, both querys return 0.

We know it's random because we've run the aboth quries several times..

Unluckerly this is on a production server

dan

No, it returns 0.

The results we get back seam to be completly random.

Sometimes there similar to what has previously been requested but seam to fluxuate(sp).

dan

Edited by - dreaddan on 03/25/2003...

HI, the box is unticked.

dan