Hi,
I'm using SQL2000 transaction replication. I'd like to find out
exactly when individual transactions are committed on the publisher
side, before they are actually replicated. Is there a system table
that holds this info? I've looked at MSDistribution_History and
MSqreader_History but they don't have what I'm looking for. Is there a
system variable that I can tap into that may have this (like DB2
has)?
Any thoughts?
Thanks,
Glenn
Glenn,
you can use sp_browsereplcmds which queries the MSrepl_commands table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment