I have an application running in two servers. When I try using SQL Profiler for tracing whats going on in my database when saving data.   
I received `IF @@TRANCOUNT > 0 ROLLBACK TRAN` in Server **A** after trying to insert data in database. While on the other server I received `IF @@TRANCOUNT > 0 COMMIT TRAN` in Server **B**.

Any ideas what cause the rollback tran? I am using the same application in both servers.