SQL Server Bug:sp_replqueuemonitor performs no results in SQL Server (RTM)

Current version: Windows Server R2 SP1 + SQL Server (RTM)

Sp_replqueuemonitor

This stored procedure lists queue messages for queued updating subscriptions for a MicrosoftSQL Server queue or for a specified publication in Microsoft Message Queuing.
(in the subscription database, view the command that the queue is executing (or blocking)-that is, synchronizing from the subscription back to the published command)

However, the stored procedure does not return any results in Windows Server R2 SP1 + SQL Server (RTM) (large transactions are still in the queue)

Previously in Windows 2003 R2 SP2 + SQL Server (RTM), it was performed normally.

Stored procedure parameters are obtained:

SELECT TOP 5 tranid,count (*)  Cmdfrom [platform].[ DBO]. [MSreplication_queue] (NOLOCK) GROUP by Tranid ORDER by CMD descselect Publisher, publisher_db, publication from dbo. MSsubscription_agents

The stored procedure executes at the subscription database:

exec sys.sp_replqueuemonitor ' publisher ', ' publisher_db ', ' publication ', ' Tranid ', 0

Last confirmed as a bug in SQL Server:

Fix:no rows is returned when you use the Sp_replqueuemonitor stored procedure to list the queued messages for a queue-up Dating subscription in SQL Server

Reason

The problem occurs because the internal query statement for the stored procedure Sp_replqueuemonitor uses an incorrect value for the column queue_id.


In stored procedure sp_replqueuemonitor, some queries use the value of queue_id as the query condition.
However, an incorrect value is defined mssqlqueue the correct value is replaced Mssqlqueuev2

Cumulative update package SP1 needs to be installed.

Cumulative update package 1 for SQL Server 2008

However, I am currently upgrading directly to SP4 (Service Pack 4)

SQL Server Service Pack 4:download

SQL Server Bug:sp_replqueuemonitor performs no results in SQL Server (RTM)