Reading the logfiles

Is there any information out there on how to read the SQL Server 2k log
files.  The following are two things I dont want to do - 1. use a third part
y
tool (ie; Lumigent Log Explorer) and 2. Turn on trace/profiling.  I just wan
t
to read the log files - somebody must know how to do it if there are 3rd
party tools...

You're on the right track with reading log files - Lumigent is the best tool
for this (they've been around for years). You can also use fn_dblog()
though, eg: SELECT * FROM ::fn_dblog(null, null)

Performing trace / profiling is a bugger with SQL 2000 in many ways. Hence,
I've designed a tool called SQLBenchmarkPro which makes this MUCH easier.
We've got a nice beta available for free right now which you're welcome to
pull down & try out from: http://www.gajsoftware.com

HTH

Regards,
Greg Linwood
SQL Server MVP

" MSSQLServerDeveloper
" < MSSQLServerDeveloper
@discussions.microsoft.com>
wrote in message news:9E1B5217-D450-491E-83E5- D19BE190E9F8@microso
ft.com...
> Is there any information out there on how to read the SQL Server 2k log
> files.  The following are two things I dont want to do - 1. use a third
> party
> tool (ie; Lumigent Log Explorer) and 2. Turn on trace/profiling.  I just
> want
> to read the log files - somebody must know how to do it if there are 3rd
> party tools...