>>Also, apparently your code can not properly determine this error condition and somehow eats the error. You may want to trace this part of the code also.
>
>Been there, done that - works just fine, command looks good - no error generated
How far have you traced? What is the code that executes the command - are you using ADO.NET?
Also, do these tables have triggers?
If it's not broken, fix it until it is.
My Blog