Audit Trail + Delphi+master-detail table + triggers + sp

See more:

SQL-Server

SQL-Server-2008

, +

Hello.....
I am implementing Audit Trail in Sql Server 2008 R2 and Delphi 7. I have created trigger in master and detail table. and called SP with cursor and some other logic.
while trying to do data entry in Master - Detail form I am getting Error ..
"CANNOT Save - Cannot create new connection because in manual or distributed transaction mode."

Please Please do needful... Thanks a lot in advance for your help...