Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanksI don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:
> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>>I don't of any free tools. As a matter of fact, they are pretty pricey
>>since people are usually in a bind when they go looking for them. However,
>>I believe they are just a gui on dbcc log so you could look into that
>>command. It is pretty cryptic though.
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://feeds.feedburner.com/statisticsio
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>>|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>