>Right-o, Mike. AFAIK, SQL Server is wrappering transactions as it's end with automatic transactions. BTW, I find that manual transactions from the VFP end are much more flexible.
Be careful with VFP 'manual SQL transactions' on SQL Server. I haven't checked to see if the implementation has changed, but when I got bit, VFP was enabling SQL Server implicit transactions connection setting. This means that any DML command causes a transaction to begin and you have to explicitly terminate the transaction. But the next DML command will again start a transaction. The implicit transaction setting is not reset until you disable VFP's manual transactions.
-Mike