DBCC Opentran

  • When I run the dbcc opentran. The results are below

    Why it din't give me any spid id?

    Replicated Transaction Information:

    Oldest distributed LSN : (1103164:1881:8)

    Oldest non-distributed LSN : (0:0:0)

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  • It doesn't show you a session ID because that section of information is about replication, not active transactions. The presence of that section just means that the current log contains information for replicated transactions.

    Cheers!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply