Re: Splitting of transaction during transactional replication

MaxCmdIntran is a log reader agent only property. There is no message logged
to the history tables saying that the splitting has occurred.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"andsm" <andsm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:00DC58A9-6CF7-45B5-BF6F-4375CDF0CA88@xxxxxxxxxxxxxxxx
I want to split transactions in transaction replications SQL2k, in case if
the transaction is too huge. I think about setting MaxCmdInTran to 1000000
for logreader and similar for distribution agent. In current DB schema
such
transactions should never occur. But in case if the transaction happened,
I
want to get at least fact what the splitting happened. Is any way to find
such cases, when transaction was splitted by replication?


.