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 application updates the tables, which 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 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?...
> >
> >
>
>|||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.
> regards,
>
> "Greg Linwood" wrote:
> > 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 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...
> > 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
> 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?...
> > > >
> > > >
> > >
> > >
> > >
>
>|||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.
> 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...
> > > 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
> > 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?...
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >