Applies to
-
All versions after Service Pack 3 (SP3) (including it) for SQL Server 2014
-
All versions after SP2 (including it) for SQL Server 2016
-
Cumulative update 3 to 19 (both inclusive) for SQL Server 2017
-
All versions before cumulative update 5 for SQL Server 2019
Symptoms
Assume that you use one of these SQL versions mentioned in the "Applies To" section. If you enable output verbose log for distribution agent, you will notice that the OUTPUT of the Distribution Agent contains summary information that does not include the following information:
DateTime Last transaction timestamp: 0x00000033000000ff00bc00000000
Transaction seqno: 0x00000033000001500023
Command Id: 1
Partial: 0
Type: 30
Command: <<ParameterizedCommand>>
DateTime sp_MSget_repl_commands timestamp returned: 0x0x0000003300000150002300000000, 1, local rowcount: 1
DateTime Parameterized values for above command(s): {{1.1000, 43659, 2}}sp_MSget_repl_commands timestamp value is: 0x0x0000003300000150002300000000
Resolution
This issue is fixed in the following cumulative updates for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Workaround
To work around this issue, you can define OutputVerboseLevel as part of Distribution agent profile parameters. For example, if Distribution agent is using default agent profile, create a new profile and add OutputVerboseLevel parameter with its value there. And then use that profile for distribution agent.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.
