Results 1 to 3 of 3

Thread: Transaction log

  1. Aug 15th, 2001, 02:00 AM #1
    fredrik
    fredrik is offline

    Thread Starter
    Lively Member
    Join Date
    May 2001
    Location
    Falkenberg, Sweden
    Posts
    76

    Transaction log

    Is it possible to look at the transaction-log in SQLserver 2000?

    What I want to do is to look at all inserts/updates/deletes and beginTran/RollbackTran that have been executed last night.

    Thanks in advance!
    ________________________
    Fredrik Klarqvist
    Reply With Quote Reply With Quote
  2. Aug 15th, 2001, 02:40 AM #2
    rudgej
    rudgej is offline
    Hyperactive Member
    Join Date
    Jan 2000
    Location
    Edinburgh, Scotland
    Posts
    272
    Could you not just create a table that you log transaction info into when doing the normal database stuff?
    Reply With Quote Reply With Quote
  3. Aug 15th, 2001, 05:18 AM #3
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    This can't be done through Enterprise Manager
    You need to get third-party tools to look at the transaction logs and these can cost a packet. I think a company called Embarcadero release one but I don't have the details.
    Try doing a search on http://www.swynk.com/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width