• Weird that it's deadlocking on a page. Since you have the page address (5:1:1662692), it would be nice to see what the actual deadlocked resource is.

    Print the page header with the following code, and report back what you see for the following values:

    m_type

    Metadata: IndexID

    Here's the code:

    DBCC TRACEON(3604);

    DBCC PAGE(5, 1, 1662692);

    Eddie Wuerch
    MCM: SQL