Replication Progress

How can I see what the pending transacions are for a given server? Is
there an app that will show me this, or do I have to query a table?
TIA,
Larry...
If you are talking about transactional replication, sp_browsereplcmds can be
used. To filter out commands already replicated, you have to provide the
@.xact_seqno_start argument. The relevant value will be in the
MSreplication_subscriptions table - transaction_timestamp column.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?

Replication Monitor Bug?

There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.

Here is my setup:

Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()

When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:

Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)

If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.

If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.

You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg

Thanks In Advance.

Martin

Thanks Martin, can you log this issue at the connect/feedback site so we can have someone look at it?