Logparse does not take date parameters

Hi,

I follow MAK's instruction here: http://www.databasejournal.com/featu...0894_3515886_1

The problem is that it works only on the local machine server 2k3 with sql 2k5 installed. I have 2 other boxes( 2k3 and 2k server) that need to extract the security log.

I manually ran the logparser.exe with the same sql parameter but it didn't work either. If I leave out the WHERE clause, it works fine. But then, it pulls entire log file.

It does not spit out any hint nor error.

Please help.

TIA,

Cal

i wrote this in June 2005. I haven't tested the code for sql server 2005. Let me take a look.

Hi Mak,

Any luck?

Cal