• hi, I had similar problem a few years back... if im not mistaken, it all depended on the driver used to set up the linked server.

    if used Microsoft driver (ODBC) then the top x works fine and if the driver was Oracle's then must use the rownum clause....