Does anyone know if there is a performance difference or any other significant factor between creating a linked server from a SQL Server 2005 server to a SQL Server 2000 server using OLE versus SQL Native client as the provider? What does/can the provider type affect?
Thank you in advance for any insight into this question.