assuming i am using a properly configured version of SQL Server 6.5

which method results in better query performance ?

Remote views or SQL pass through?

which method gives better batch update performance ?

if i send a query through SQL pass through does the SQL syntax have to be in the server's SQL syntax or in VFP SQL-Select syntax ?

do i have to learn the SQL syntax of SQL Server 6.5 if i use SQL pass through to access its data ?


TIA, Dave