I have setup a linked server and fired the SQL below in 'Query Analyser'. There are 27 records in the Oracle table, but when this query is run, it only returns 2 rows (I can sort DESC and show the last 2 rows!!), this is the same for all tables I query against, how do I see all rows? am I missing a config setting?

SELECT * FROM OPENQUERY (ORACLE, 'SELECT * FROM <tableName>')

Any Help Welcome
Ian

Try the following command in your query analyzer and then run the query.

SET ROWCOUNT 0

SET ROWCOUNT 0 has made no difference. The linked server is mapped to a System ODBC (that when used in MS Access I can see all rows to a linked table).

the reason why I am using a linked server is that I want to get some data from Oracle based on some rows from SQL Server. Is this the only way?. (The only fix I have found at the moment is to create a base table in Oracle and send the results from SQL to Oracle using a DTS package and then re import all the data back into SQL Server - i'm sure not the best way)

Solution
I have just created another linked server but used Microsoft OLE DB Provider for Oracle, previously I used Microsoft OLE DB Provider for OBDC Connections. I am sure I tried the Oracle Driver previously with the same results, therefore SET ROWCOUNT 0 must have help as well

Thanks ram2098