>What is the correct syntax for adding a linked server into SQL2000 which is a fox free table directory
>
>how do you call these 2 extended procs?
>sp_addlinkedserver
>sp_addlinkedsrvlogin
>
>tia

-- Using OLEDB provider for VFP
sp_addlinkedserver @server = 'test', 
	@srvproduct = 'VFP',
	@provider = 'VFPOLEDB.1', 
	@datasrc = 'H:\Temp', 
	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
-- Using OLEDB provider for ODBC
sp_addlinkedserver @server = 'test1', 
	@srvproduct = 'VFP-ODBC',
	@provider = 'MSDASQL', 
	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=; 
		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No; 
		Exclusive=No; SourceType=DBF;SourceDB=h:\Temp'

Be advised that in my tests the linked server to VFP free tables that uses OLEDB provider for ODBC was considerably faster.