Post reply

view transactions

  • May 20, 2009 at 12:58 pm

    #137845

    hello,

    I'm looking for a query or a way out to be able to view the transactions that occurs in a database and when it occurs.

    Thanks

    Shruti

  • May 22, 2009 at 9:40 am

    #998947

    Cant you use profiler? It will catch everything

    or maybe I did not understand your question properly

    -Roy

  • May 22, 2009 at 7:01 pm

    #999263

    thanks for all your replies. I was able to get it from the default trace. But, i did a restart of SQL server after the emergency occured. So, the default trace gives me info only from the restart onwards and not before that.

    Is there a way to find the transactions before that?

    Thanks

    Shruti

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

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