>I'm thinking that having trnsaction.commit() right after BeginExecute may be causing the problem. Anyway, I left everything not working, but I called later and the manger told me that he fixed everything and moved my code to production and the original problem seems to be fixed.

Yes, that seems odd to commit the transaction right after you begin to execute the command. That doesn't make sense I don't think.

So, he fixed the problem (the problem with the transaction?) ... what turned out to be the problem?

~~Bonnie