different length xact_seqno and transaction_timestamp

Hi NG
In transactional replication I found a different length of
the following varbinary(16) fields:
select xact_seqno from distribution..msrepl_transactions
go
RESULT:
0x000000110000171B0001
but
select transaction_timestamp from MSreplication_subscriptions
RESULT:
0x000000110000171B000100000000
Its an german sql server 2k with sp3
Is this a bug or a feature?
thanks
Thomas
Thomas,
it's a feature :-). As you have probably guessed, the 8 trailing zeros can
be ignored.
Regards,
Paul Ibison
|||MSrepl_commands contains two types of commands 1) sync commands constructed by the Snapshot Agent or snapshot.exe, 2) commands constructed by the log reader.
The long ones are commands constructed by the snapshot.exe binary. These are ones that are used to replicate the schema and related replication metadata to the subscriber(s).
The short ones are ones that are generated by the log reader agent or logread.exe. These are either sql commands with parameters or stored procedure calls with parameters.
You can view them by using sp_replbrowsecmds.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html