That's very interesting - I got the index definition from the query analyzer so I just kind of trusted it. I'll try adding another index as you have defined it...

Well, the solution has been found: the guy who designed the database didn't anticipate the size it would grow to and failed to create an index on the table in...

As far as I know the answer to those two questions is "no". I'll certainly look into it though.

UPDATE: the re-indexing has not solved the problem so w're updating the...

Grant,

Duly noted - thanks for the extra tips. One day I swear I will get the boss to send me on a SQL Server DBA course of some sort.

Cheers,

Tony.

Grant,

Thanks for that - I did wonder if it was something to do with an index corruption or failure. We've instituted a re-indexing of the database in question and hopefully...