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!
Printable View
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!
Could you not just create a table that you log transaction info into when doing the normal database stuff?
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/