[quote user="qbernard"]Hehe.. I don't have the same password nor pattern for every sites I associated with :) You got 1 more year to go before I change it.[/quote]

I have some time data in logs with a sub-second time resolution. I can get this safely into log parser using the iTsFormat setting. When I put that into SQL Server 2008 I have (so far) gotten the times in seconds (loss of resolution). The target field is datetime2 (not datetime). How do I preserve the...

Hi: Need a little help as I'm not very good at the sql language as yet. This is the query I'm using: SELECT date,time,c-ip,s-port,cs-method,sc-status,cs-host,cs-uri-stem FROM c:\iislogfiles\W3SVC1\extend1.log, c:\iislogfiles\W3SVC30103697\extend1.log, c:\iislogfiles\W3SVC54472458\extend1.log...

New to log parser but looks like a great tool. Anyone here use it to calculate real world think times for given requests/pages for use in VSTS load/performance testing? I tried doing some searching of the forum without luck, so hopefully I'm not asking an already answered question. Thanks!

logparser i:iisw3c -q:on "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss')" Error: detected extra argument "select distinct c-ip from ex081103.log where to_timestamp (time) = timestamp ('02:18:49','hh:mm:ss'...

As expected, you guys took a perfectly good design (the old one) and turned it into an eyesore (this one). It's becoming quite the forte for Microsoft Community sites. Don't worry about bugs, just re-design the damn thing! Idiots.