>How to enable logging in SQL server 2000
>I want to log each and every transaction done in sql.
>like in oracle we have concept of Redo log files
>
>TIA
Everything already is logged, you just need to know how to read it. Or, you can use some software to read it. Check out the Lumingent Log Analyzer.
http://www.lumigent.com/LogExplorer/analyze.htmBOb