Select * From OpenQuery (Ftw003, 'Select * From Mold');
Returns one row from a table that has 12837 records
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Ian Roke · Feb 13, 2010 at 03:05 PM
Something like this should hopefully do the trick?
'SELECT * FROM Mold'
Answer by Rob Farley · Jan 02, 2010 at 10:46 AM
Try using OPENROWSET instead. It could be something around the fact that OQ only returns one resultset, which could perhaps be getting confused depending on what your linked server is.
Answers Answers and Comments
No one has followed this question yet.
How to dinamically query the first available Active Directory Servers
What's the possible reason why OpenQuery is not working
Insert into openquery MySQL
How to Use Open Query in a stored procedure on a linked server
Linked server query from Oracle DB is truncating aggregate function results.