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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×