Have you ever got a task that required reading and parsing log files?
Well Log Parser 2.2 is the tool for you. Log parser is a powerful, tool that provides SQL query syntax to text-based data such as log files, XML files and CSV files. It also support Windows operating system files such as the Event Log, Registry, the file system and Active Directory.
You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.
There is also nice open source tool named: Visual Log Parser that helps you build and check you SQL log parser queries.
I recommended this tool because it has great perfomance and also very easy to use.
Rotem (Rock) Bloom