Post reply

Finding uncommited transaction

  • November 24, 2008 at 10:49 pm

    #72303

    HI,

    Consider a scenario where a developer has fired a huge query in sql server 2000 with Begin Tran and by mistake or accidently has not commited that transaction with Commit Tran.

    Being a DBA how would I be able to identify if there are such uncommited transactions ?

    Thanks...

  • November 24, 2008 at 11:36 pm

    #902930

    Tanveer (11/24/2008)

    HI,

    Consider a scenario where a developer has fired a huge query in sql server 2000 with Begin Tran and by mistake or accidently has not commited that transaction with Commit Tran.

    Being a DBA how would I be able to identify if there are such uncommited transactions ?

    Thanks...

    Use DBCC Opentran

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • November 25, 2008 at 2:43 am

    #902983

    Got the soln...

    Thanks

  • November 25, 2008 at 2:50 am

    #902988

    Tanveer (11/25/2008)

    Got the soln...

    Thanks

    welcome

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

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

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