The web page Performance and Tuning Series: Locking and Concurrency Control - Introduction to Locking - Table Locks says that:
And that page says:
That page seems to imply that other processes can take out page level locks, even with an "Intent exclusive table lock Update page" active.
But looking at Performance and Tuning Series: Locking and Concurrency Control - Introduction to Locking - Lock Compatibility and Lock Sufficiency, it seems to say an "exclusive intent lock" blocks all other page locks.
Does an exclusive intent table lock block other page level locks? The documents are unclear. Here's my proposed fix:
Ben Slade