...fine when you are dealing with smaller sub-sets of data but has several limitations in terms of: a. the data-typessupported by the provider/ODBC driver that has been used for creating the linked server, b. Performance is not good for...
http://decipherinfosys.com/Heterogeneous_RDBMS_1.pdf