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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment