Please explain transactions within sqlserveradapter.rb?

Hello everyone,

I am needing to resolve an error on sqlserveradapter revolving around a
trigger on a table. When the AR object is saved, AR throws

Cannot create new connection because in manual or distributed
transaction
mode.

at

from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in
`log’

In order to resolve this, I need to understand how the
connection/transaction is setup in AR. This may also require my
learning of
the DBI::ADO functionality as well.

Who will step up to the plate and begin a conversation with me on this?

Thank you!