Log Explorer

Is there any way to find out what is in the Database log
file without using a third party utility (Something from
SQL Server itself or Microsoft) ' Another words, track
the transactions in the log.....
Thanks.AFAIK, Log Explorer from Lumigent is the only tool capable of doing such
thing...
-Argenis
"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:53f101c5232a$7c1d9800$a401280a@.phx.gbl...
> Is there any way to find out what is in the Database log
> file without using a third party utility (Something from
> SQL Server itself or Microsoft) ' Another words, track
> the transactions in the log.....
> Thanks.|||I've listed three such tools on the links page on my web site (see my signature).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> wrote in message
news:uGJ7qwyIFHA.2648@.TK2MSFTNGP14.phx.gbl...
> AFAIK, Log Explorer from Lumigent is the only tool capable of doing such
> thing...
> -Argenis
> "Rick" <anonymous@.discussions.microsoft.com> wrote in message
> news:53f101c5232a$7c1d9800$a401280a@.phx.gbl...
>> Is there any way to find out what is in the Database log
>> file without using a third party utility (Something from
>> SQL Server itself or Microsoft) ' Another words, track
>> the transactions in the log.....
>> Thanks.
>|||And LogPi (www.logpi.com)
Regards
Mike
"Argenis Fernandez" wrote:
> AFAIK, Log Explorer from Lumigent is the only tool capable of doing such
> thing...
> -Argenis
> "Rick" <anonymous@.discussions.microsoft.com> wrote in message
> news:53f101c5232a$7c1d9800$a401280a@.phx.gbl...
> > Is there any way to find out what is in the Database log
> > file without using a third party utility (Something from
> > SQL Server itself or Microsoft) ' Another words, track
> > the transactions in the log.....
> >
> > Thanks.
>
>|||Microsoft or SQL Server does not have such tool woul be
sufficient (Read the question) !!!!!!!!!!!!!
>--Original Message--
>Is there any way to find out what is in the Database log
>file without using a third party utility (Something from
>SQL Server itself or Microsoft) ' Another words, track
>the transactions in the log.....
>Thanks.
>.
>|||Relax. You ask a question and get some additional information. How can this make you angry?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:50ea01c52337$f3f09190$a601280a@.phx.gbl...
> Microsoft or SQL Server does not have such tool woul be
> sufficient (Read the question) !!!!!!!!!!!!!
>
>>--Original Message--
>>Is there any way to find out what is in the Database log
>>file without using a third party utility (Something from
>>SQL Server itself or Microsoft) ' Another words, track
>>the transactions in the log.....
>>Thanks.
>>.|||Your links don't give me anything...Are you just
advertising yourself !!!!!!!!!!!
>--Original Message--
>Relax. You ask a question and get some additional
information. How can this make you angry?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Rick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:50ea01c52337$f3f09190$a601280a@.phx.gbl...
>> Microsoft or SQL Server does not have such tool woul be
>> sufficient (Read the question) !!!!!!!!!!!!!
>>
>>--Original Message--
>>Is there any way to find out what is in the Database log
>>file without using a third party utility (Something from
>>SQL Server itself or Microsoft) ' Another words, track
>>the transactions in the log.....
>>Thanks.
>>.
>
>.
>|||> Your links don't give me anything...
Since you asked about reading the transaction log, I thought that knowledge about the log reader
tools available could be interesting. I've listed three such tools in my website, on my links page:
http://www.karaszi.com/SQLServer/links.asp
I might have been wrong in that assumption...
> Are you just
> advertising yourself !!!!!!!!!!!
On my website, I have a links page, a number of technical articles with tips, gotchas and other
technical information, about newsgroups and other stuff. I also mention who I am. I leave it up to
the reader to determine whether the website has any value or only serve as a mean to advertise
myself.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:553c01c5233f$bb049a40$a401280a@.phx.gbl...
> Your links don't give me anything...Are you just
> advertising yourself !!!!!!!!!!!
>
>>--Original Message--
>>Relax. You ask a question and get some additional
> information. How can this make you angry?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>http://www.sqlug.se/
>>
>>"Rick" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:50ea01c52337$f3f09190$a601280a@.phx.gbl...
>> Microsoft or SQL Server does not have such tool woul be
>> sufficient (Read the question) !!!!!!!!!!!!!
>>
>>--Original Message--
>>Is there any way to find out what is in the Database log
>>file without using a third party utility (Something from
>>SQL Server itself or Microsoft) ' Another words, track
>>the transactions in the log.....
>>Thanks.
>>.
>>
>>.|||Did not want to be rude......Some people have the
obsession to send people to their web site for
anything.....I knew that there wasn't a clear-cut
answer......It is our management getting pressured from
the security companies and pushing it down to us. The
problem is that they are cheap enough not to get any third
party utilities and act like bunch of morons when you
explain them what is available in SQL Server and what is
available out there......did not mean to take out of
you....
Thanks.
>--Original Message--
>> Your links don't give me anything...
>Since you asked about reading the transaction log, I
thought that knowledge about the log reader
>tools available could be interesting. I've listed three
such tools in my website, on my links page:
>http://www.karaszi.com/SQLServer/links.asp
>I might have been wrong in that assumption...
>
>> Are you just
>> advertising yourself !!!!!!!!!!!
>On my website, I have a links page, a number of technical
articles with tips, gotchas and other
>technical information, about newsgroups and other stuff.
I also mention who I am. I leave it up to
>the reader to determine whether the website has any value
or only serve as a mean to advertise
>myself.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Rick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:553c01c5233f$bb049a40$a401280a@.phx.gbl...
>> Your links don't give me anything...Are you just
>> advertising yourself !!!!!!!!!!!
>>
>>--Original Message--
>>Relax. You ask a question and get some additional
>> information. How can this make you angry?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>http://www.sqlug.se/
>>
>>"Rick" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:50ea01c52337$f3f09190$a601280a@.phx.gbl...
>> Microsoft or SQL Server does not have such tool woul
be
>> sufficient (Read the question) !!!!!!!!!!!!!
>>
>>--Original Message--
>>Is there any way to find out what is in the Database
log
>>file without using a third party utility (Something
from
>>SQL Server itself or Microsoft) ' Another words,
track
>>the transactions in the log.....
>>Thanks.
>>.
>>
>>.
>
>.
>|||No worries.
Short answer is that SQL Server doesn't come with a log reader tool. There are two commands to
output t-log entries, but they are more or less binary information with which you can't decipher
anything useful. So in other words, if you want to read the log, you need a 3;rd party tool.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:561701c5234d$d0bd5490$a401280a@.phx.gbl...
> Did not want to be rude......Some people have the
> obsession to send people to their web site for
> anything.....I knew that there wasn't a clear-cut
> answer......It is our management getting pressured from
> the security companies and pushing it down to us. The
> problem is that they are cheap enough not to get any third
> party utilities and act like bunch of morons when you
> explain them what is available in SQL Server and what is
> available out there......did not mean to take out of
> you....
> Thanks.
>
>>--Original Message--
>> Your links don't give me anything...
>>Since you asked about reading the transaction log, I
> thought that knowledge about the log reader
>>tools available could be interesting. I've listed three
> such tools in my website, on my links page:
>>http://www.karaszi.com/SQLServer/links.asp
>>I might have been wrong in that assumption...
>>
>> Are you just
>> advertising yourself !!!!!!!!!!!
>>On my website, I have a links page, a number of technical
> articles with tips, gotchas and other
>>technical information, about newsgroups and other stuff.
> I also mention who I am. I leave it up to
>>the reader to determine whether the website has any value
> or only serve as a mean to advertise
>>myself.
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>http://www.sqlug.se/
>>
>>"Rick" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:553c01c5233f$bb049a40$a401280a@.phx.gbl...
>> Your links don't give me anything...Are you just
>> advertising yourself !!!!!!!!!!!
>>
>>--Original Message--
>>Relax. You ask a question and get some additional
>> information. How can this make you angry?
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>http://www.sqlug.se/
>>
>>"Rick" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:50ea01c52337$f3f09190$a601280a@.phx.gbl...
>> Microsoft or SQL Server does not have such tool woul
> be
>> sufficient (Read the question) !!!!!!!!!!!!!
>>
>>--Original Message--
>>Is there any way to find out what is in the Database
> log
>>file without using a third party utility (Something
> from
>>SQL Server itself or Microsoft) ' Another words,
> track
>>the transactions in the log.....
>>Thanks.
>>.
>>
>>.
>>
>>.