DBCC opentran

  • hi all,

    I run "DBCC opentran " - even that says there are no

    active open transactions. Am i missing some thing - from where does perfmon fetch this information. Any help greatly appreciated

    command :- dbcc opentran

    message is-

    No active open transactions.

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

    Thanks in advance

  • what are you expecting to see?

    what is the reason for executing dbcc opentran?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • If it reports no transactions, you have no open transactions in that database.

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

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