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()?
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05