>In FoxPro Rollback rolls back to the point at the last begin transactions.
>SQL Server however rolls back all transactions when i instruct him ROLLBACK TRANSACTION.
>Does anybody know why this is and what could be done about this?
>
>Marco.

This is the behavior in SQL Server. If you want to rollback a part of the transaction, create a savepoint with the SAVE TRANSACTION statement. Then you can have you can rollback to the savepoint.

HTH

-Mike