Would think that if there are going to be a huge number of inserts/updates, disabling a non clustered index would greatly help perfomance - no?

Well, dont know if this will help but your post reg turning off TRAN solved my problem. Was getting the same error and couldn't figure out what was causing it...