Home Forums SQL Server 2005 Administering deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. RE: deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim.

  • March 24, 2016 at 1:57 pm

    #1867612

    If your query allows uncommitted reads, another option is to use WITH (NOLOCK).