SELECT * FROM OPENQUERY (DBF, 'SELECT * FROM wrk3')
(строк обработано: 19111)
9 секунд

EXEC sp_addlinkedserver
'DBF',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'd:\',
NULL,
'dBase IV'

/****** Объект:  LinkedServer [DBF]    Дата сценария: 01/07/2013 12:11:12 ******/
EXEC master.dbo.sp_addlinkedserver 
   @server = N'DBF', 
   @srvproduct=N'Jet 4.0', 
   @provider=N'Microsoft.Jet.OLEDB.4.0', 
   @datasrc=N'd:\', 
   @provstr=N'dBase IV'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin 
   @rmtsrvname=N'DBF',
   @useself=N'True',
   @locallogin=NULL,
   @rmtuser=NULL,
   @rmtpassword=NULL

GO
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'collation compatible', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'data access', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'dist', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'pub', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'rpc', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'rpc out', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'sub', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'connect timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'collation name', @optvalue=null
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'lazy schema validation', @optvalue=N'false'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'query timeout', @optvalue=N'0'
EXEC master.dbo.sp_serveroption @server=N'DBF', @optname=N'use remote collation', @optvalue=N'true'
GO