I'm encountering a strange problem with OPENROWSET.
I have an INSERT INTO..<a local table> SELECT * FROM OPENROWSET(...) statement
which is fetching() less number of rows than actual. I mean if I run the query on the remote server (without the OPENROWSET) by connecting thru query analyzer I get the desired number of rows. Has anyone seen/heard a similar problem? Any ideas??