Beginning transaction in sql server 2008

  • Hello team,

    I am using following version of sql server

    @@version = Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3).

    I run following command to open one transaction

    begin tran aa

    go

    But dbcc opentran() doesn't give me any information.

    --No active open transactions.

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

    But when I execute commit then the transaction is committed.

    Is there any change in opening the transaction in sql server 2008?

    -LK

  • If you’ll check the value of @@trancount, you’ll see that it is 1. Also if you’ll run a statement that modifies any data in the transaction before you run the dbcc opentran statement, you’ll see that there is an open transaction. Since you opened a transaction, but didn’t modify any data at all, the DBCC OPENTRAN statement didn’t return data about any open transaction

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Thanks Adi.

    -LK

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

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