Home Forums SQL Server 2005 Administering Check Statement aborted. Database contains deferred transactions. RE: Check Statement aborted. Database contains deferred transactions.

  • July 2, 2010 at 1:25 am

    #1188030

    Hi ,

    Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    DBCC OPENTRAN

    Transaction information for database 'DB'.

    Oldest active transaction:

    SPID (server process ID): 51

    UID (user ID) : -1

    Name : implicit_transaction

    LSN : (412576:18904:9)

    Start time : Jul 2 2010 4:17:57:390AM

    SID : 0x17077e53df9a7346bb0ec67e76740828

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

    DBCC check db

    Msg 7929, Level 16, State 1, Line 1

    Check statement aborted. Database contains deferred transactions.