Linked Server to Oracle
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