>Connecting to SQLServer 2005, if a BEGIN TRANSACTION is sent to SQLServer, what is the safest way to determine if a ROLLBACK or COMMIT were or were not sent to end the transaction? If you send a COMMIT or ROLLBACK and no transaction is pending, you receive the SQL error...
Imho, you shouldn't send them separately, i.e. you better call SP that contains both BEGIN and COMMIT.
Edward Pikman
Independent Consultant