sql2005 , Understands xact_seqno in replication

motioneye used Ask the Experts™
In replication of sql2005, there is column xact_seqno 0x00042B7F00038BF70017000000000000

Can this means xact_seqno have one transaction equal to  0x00042B7F00038BF70017000000000000 or it can have multiple same values which means multiple transactions
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Since xact_seqno contains the log sequence number (LSN) for each failed transaction, it will always be unique and will refer to one transaction.


So, In one transaction that cab  be many commands ? am I rite ?, the reasons why I ask because I can see multiple xact_seqno which my assumption its represent a commands within a transactions.
Yes, your assumption is correct.

To get further details on that particular xact_seqno go ahead & check sp_browsereplcmds for that xact_seqno and you will be able to see the multiple commands for the particular transaction.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial