Thanks Matt for the reply.

The assembly is signed and set to Unsafe. BTW, other such code which calls external web services works fine.

The implementation in question is using MTOM...

I would break down the SQL script in to multiple pieces and commit them indipendently. In addition, I would place some logging code after each insert/update to record @@errors.

It...