Post reply

Need Query urgent..

  • April 25, 2009 at 3:00 am

    #130882

    If any one client machine done a begin transaction on my DB

    then how can we find and put a rollback for them ..

  • April 25, 2009 at 3:07 am

    #983907

    DBCC OPENTRAN will give you transactions that are open.

    with the spid you get issue a KILL command which will end the transaction.

  • April 27, 2009 at 5:26 am

    #984263

    Check this...

    http://www.sqlservercentral.com/scripts/Miscellaneous/30085/

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

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

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