Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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


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


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:


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.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!