Accessing SQL Server through SPT Pre sp1, I used a date format as in :

SQLEXEC(m.handle, [SELECT * FROM table WHERE datefrom > '2004-29-03 00:00:00'])

Using SQL profiler, we could see that the following commands were issued by VFP on SQLSTRINGCONNECT to SQL Server:

set language british
set dateformat dmy
set datefirst 1

After sp1, with no changes to the executable, this changes to:

set language us_english
set dateformat mdy
set datefirst 7

We now need to use a date format of '20042903 00:00:00' (ie no hyphens).
Two questions:

1. What is the setting in VFP that causes it to decide what set commands to use when logging into SQL Server?
2. Why does there not appear to be a universal date format for use with SQL Server that bypasses the set commands (counter to the documentation)?