sys.sp_showpendingchanges

Description

Returns a result set showing the changes that are waiting to be replicated. This stored procedure is executed at the Publisher on the publication database and at the Subscriber on The name of the server where the replicated changes are applied. This procedure provides an approximation of the number of changes and the rows that are involved in those changes.

Syntax

sp_showpendingchanges
[ [ @destination_server = ]
N
'destination_server'
]
[ , [ @publication = ]
N
'publication'
]
[ , [ @article = ]
N
'article'
]
[ , [ @show_rows = ] show_rows ]
[ ; ]