Home Forums SQL Server 2017 SQL Server 2017 - Development Message Queue stored procedure getting Deadlocked. RE: Message Queue stored procedure getting Deadlocked.

  • February 28, 2018 at 8:15 am

    #1981471

    Have a look at the READPAST hint (https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table):

    READPAST is primarily used to reduce locking contention when implementing a work queue that uses a SQL Server table