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

  • Thank u, now recovered but still am getting one transactions like

    Oldest active transaction:

    SPID (server process ID): 123

    UID (user ID) : -1

    Name : implicit_transaction

    LSN : (413051:16337:1)

    Start time : Jul 2 2010 1:55:32:310PM

    SID : 0x17077e53df9a7346bb0ec67e76740828

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