Thank you  - both of you have pointed me in the right direction. By reindexing and updating stats (after using the server trace in Query Analyzer) everything has returned to...

What an embarrasing fiasco this thread has turned into.

The answer is incorrect. Does it really require countless posts pointing out the now bleeding obvious - accompanied by the incessant whine...