sql2005 , Understands xact_seqno in replication

motioneye
motioneye used Ask the Experts™
on
Hi
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
Comment
Watch Question

Do more with

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

Author

Commented:
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.
Commented:
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