>I just tried the list structure on the misbehaving tables, the structure is correct and is exactly the same as they are on the server.

But are the view structures the same when you compare the USE MYVIEW NODATA structure to the USE MYVIEW?