🙂 Very interesting and with many information I didn't know. One more, does the ALLOW_PAGE_LOCKS option on indexes in the tables involved matters for deadlocks?

thanks

Albert

I think there must return an error message. Same thing when you try to insert some value in a field shorter than the input.

For those who say that this...