Read log files

hi,
how do i read the transaction log file. Actualy i've got a database given my
some 1 else, we do not have the db diagrams and no relationship between the
tables and no source code, can we find out that when the front end applicat
ion updates the tables, wh
ich are the table where entries r made? I wanted to use that data futher?...Check out Lumigent's "Log Explorer" product - it's built for performing log
analysis etc.
www.lumigent.com
Regards,
Greg Linwood
SQL Server MVP
"sim sim" <sim sim@.discussions.microsoft.com> wrote in message
news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> hi,
> how do i read the transaction log file. Actualy i've got a database given
my some 1 else, we do not have the db diagrams and no relationship between
the tables and no source code, can we find out that when the front end
application updates the tables, which are the table where entries r made? I
wanted to use that data futher?...
>|||hi Greg,
thanks 4 the reply, but this site give a 3rd party software 2 do the same...
can't we read the log file without this. or is there any way by which i can
find which tables are getting updated by recent transactions.
regards,
"Greg Linwood" wrote:

> Check out Lumigent's "Log Explorer" product - it's built for performing lo
g
> analysis etc.
> www.lumigent.com
> Regards,
> Greg Linwood
> SQL Server MVP
> "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> my some 1 else, we do not have the db diagrams and no relationship between
> the tables and no source code, can we find out that when the front end
> application updates the tables, which are the table where entries r made?
I
> wanted to use that data futher?...
>
>|||You might consider running a Profiler trace to track application activity.
This can be saved to a table for subsequent analysis.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> hi Greg,
> thanks 4 the reply, but this site give a 3rd party software 2 do the
same... can't we read the log file without this. or is there any way by
which i can find which tables are getting updated by recent transactions.[vbcol=seagreen]
> regards,
>
> "Greg Linwood" wrote:
>
log[vbcol=seagreen]
given[vbcol=seagreen]
between[vbcol=seagreen]
made? I[vbcol=seagreen]|||Hi Dan
Thanks a lot u'r suggestion was of great help. Can u suggest some site where
i can get good help on making use of the SQL Profiler.
Regards
"Dan Guzman" wrote:

> You might consider running a Profiler trace to track application activity.
> This can be saved to a table for subsequent analysis.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "sim sim" <simsim@.discussions.microsoft.com> wrote in message
> news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> same... can't we read the log file without this. or is there any way by
> which i can find which tables are getting updated by recent transactions.
> log
> given
> between
> made? I
>
>|||I suggest you start with the Books Online
<adminsql.chm::/ad_mon_perf_88c3.htm>. You can save the results to a table
for ad-hoc analysis. The events of interest here are the 'completed' events
for batches and RPCs. You can also add sp:statement completed if needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:9BF8F3EE-D25B-4089-9E4D-9B34CB99BF69@.microsoft.com...
> Hi Dan
> Thanks a lot u'r suggestion was of great help. Can u suggest some site
where i can get good help on making use of the SQL Profiler.[vbcol=seagreen]
> Regards
>
> "Dan Guzman" wrote:
>
activity.[vbcol=seagreen]
the[vbcol=seagreen]
transactions.[vbcol=seagreen]
performing[vbcol=seagreen]
database[vbcol=seagreen]
end[vbcol=seagreen]sql