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.

>>The SQLEXEC Command is implicitly sending a begin transaction command to the ser ver which is causing the program run by the stored procedure to fail.
>
>I've never seen SQLEXEC begin a transaction. Have you enabled manual transactions on the connection using SQLSETPROP()?
>