You're not checking if any statement is executed correctly on SQL Server. Maybe "BEGIN TRANSACTION" failed.
> >From VFP i'm persisting data into SQLServer, but roolback transaction dont work > >
>objConexao.executar("BEGIN TRANSACTION")
>objConexao.executar("Update TableName set fieldname = 11 where fieldkey = 289880")
>objConexao.executar("ROLLBACK TRANSACTION") && dont work - in SQLServer fieldname was updated to 11
>