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, 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 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...
> 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]

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?...
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

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

RB - New table info didn't show up on the Report Builder report

Hi All - I'd like to add some more info to an existing RB report by adding a new table. I am able to add a new table to DSV and build relationship. I am also able to add the table to report model as a new entity and source fields. The report model gets rebuilt and redeployed without problem, and the old report still runs fine. But when I open the report in report builder and want to add more info, the new table/entity/attributes are not showing up at all.

I've had this problem before also, sometimes when I create a report model with multiple tables I can only drag and drop values from one table onto the report builder grid. Once I drag values from the one table there is no way to go back and add values from the other table.

Why is that?

|||

A report that already contains data displays the entities related to the data already in the report. If your new entity is not related to the data in the report, you will not be able to select fields from that entity and add them to your report. If the entities should be related, make sure you have created a Role in the report model that defines that relationship.