Hi,

Is it possible to find the state of a transaction, whether it is open or not.

In my code the BeginTrans is in conditional statements, I don't want my error code to execute the RollBackTrans if the BeginTrans has not been executed.

Thanks all.