Thanks for the above posts. We have assumed it is network related but haven't been able to pin it down. Further posts still welcome if anyone else has...

In Query Analyser type Exec SP_Help tablename . You may have problems if your owner is not DBO, as SP_Help does not let you prefix the table name...

Thanks Ferguson, this worked (looks bad as you said, but actually worked), I've now got to work all the joins out to make this work with my actual data set...

Hi Ferguson, thank you for taking time out to respond. I am afraid however that I do not understand your example and explanation. From what it sounds like...