Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Exclamation Unanswered: Transaction Open

    Hi

    How do we will know whether transaction is open or closed.

    Nageswar

  2. #2
    Join Date
    Mar 2004
    Posts
    80
    SELECT @@TRANCOUNT

    returns number of active transactions for the current connection

  3. #3
    Join Date
    Jun 2004
    Posts
    19
    Thanks for your prompt reply

    it gives only count, but i need to find out which transaction is open

    Nageswar

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Dbcc Opentran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •