Post reply

How to find the last Transactions in SQL SERVER

  • December 16, 2004 at 5:43 am

    #91714

    Dear All Gurus

    How to find the last Transactions in SQL SERVER. What r the different ways to get the Last Transactions using Profiler i can check.

    Any help would be greatly appreciated

    Regds

    Dharmendra

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • December 16, 2004 at 10:39 am

    #534193

    If you were already running profiler, you could sort through the transactions, btu you'd have to know if implicit transactions were on for any connections, group up connection traces, etc.

    Lumigent, Log PI, ApexSQL, all have products to read the transaction log, one of which would be the best way to determine this.

    Why do you want this?

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • December 17, 2004 at 2:39 am

    #534286

    Dear Steve

    Thanx for your answer. I wanted to find the last transaction becoz one of my ASP script page has something to do with the SQL Procedure. And more than 23 Users executing the same page and i have saved those changes into Cookies so i wanted to find out the last Transaction that happened through Pages. So that i can find out what exactly happened. I know can be happened with Profiler.

    Regds

    Dharmendra

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • December 17, 2004 at 2:44 am

    #534287

    There is

    select top 10 * from ::fn_dblog( default, default )

    but it does not give the actual sql statements.

    karl

    Best regards
    karl

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

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