SQL Server Error Msg 21754 – Processing has been terminated. The resultset for sp_getqueuedrows is larger than 16,000, the maximum size that the procedure can return. Run the Queue Reader Agent to flush the queue at the Subscriber before executing this procedure again.

In this blog post, let’s learn about the error message “21754 – Processing has been terminated. The resultset for sp_getqueuedrows is larger than 16,000, the maximum size that the procedure can return. Run the Queue Reader Agent to flush the queue at the Subscriber before executing this procedure again.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21754 – Processing has been terminated. The resultset for sp_getqueuedrows is larger than 16,000, the maximum size that the procedure can return. Run the Queue Reader Agent to flush the queue at the Subscriber before executing this procedure again.

Reason for the Error

To be update soon…

Solution

To be update soon…