Worked it out - it was table specific. I was wrongly informed it was affected all tables.

The table had a "." in it which Query Analyser didn't like.