In this blog post, let’s learn about the error message “21189 – The queue for this subscription with queue_id = ‘%s’ is not empty. Run the Queue Reader Agent to make sure the queue is empty before setting mode from [queued] to [immediate].” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21189 – The queue for this subscription with queue_id = ‘%s’ is not empty. Run the Queue Reader Agent to make sure the queue is empty before setting mode from [queued] to [immediate].
Reason for the Error
To be update soon…
Solution
To be update soon…