>BTW - Does this mean that when TRANSACTIONS is on manual, when you start work with the server, Fox automatically begins a transaction IN SQL SERVER (rather than a Fox Transaction) and that therefore it's up to you to do an SQLCOMMIT() or and SQLROLLBACK() to end the transaction?

Close - If implicit transactions are enabled, most SQL commands (like SELECT, INSERT, DELETE, and UPDATE) will cause SQL Server to implicitly execute a BEGIN TRANSACTION. VFP and ODBC really don't have anything to do with it except submit the commands. All commands submitted after the first one will reside within the transaction. All locks will be held until the transaction is completed. The SQLCOMMIT() and SQLROLLBACK() SPT commands are just wrappers for submitting a COMMIT TRANS and ROLLBACK TRANS commands.

You can control transactions without enabling implicit transactions by submitting the BEGIN TRANS and COMMIT TRANS youself using SQLEXEC().

-Mike