Sorry I misunderstood. I thought your successful INSERT was done entering data directly in the tables in SSMS.

Can you run profiler during during the success and failure and see if there are differences?