Analyze LDF files MS SQL Server 2000

Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
I mean, a tool that converts a LDF file in a set of SQL transactions?
(similar to dbtran in sybase)

thanks!"Esteban" <ecastillo@.gmail.com> wrote in message
news:8f83567b.0406180752.1b24d5ff@.posting.google.c om...
> Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
> I mean, a tool that converts a LDF file in a set of SQL transactions?
> (similar to dbtran in sybase)
> thanks!

There is nothing in MSSQL itself (except for some undocumented commands),
but there are third-party tools available, such as this one:

http://www.lumigent.com/

If you are trying to achieve something specific, you might want to post more
details of your goal, and someone may be able to suggest something.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<40d3fef1_2@.news.bluewin.ch>...
> "Esteban" <ecastillo@.gmail.com> wrote in message
> news:8f83567b.0406180752.1b24d5ff@.posting.google.c om...
> > Anybody nows a tool to analyze LDF files in MS SQL Server 2000?
> > I mean, a tool that converts a LDF file in a set of SQL transactions?
> > (similar to dbtran in sybase)
> > thanks!
> There is nothing in MSSQL itself (except for some undocumented commands),
> but there are third-party tools available, such as this one:
> http://www.lumigent.com/
> If you are trying to achieve something specific, you might want to post more
> details of your goal, and someone may be able to suggest something.
> Simon

Thanks Simon, I was trying this product, but I can't find an option
that shows me a list of SQL transactions made in the database ...
maybe I don't know how to use it.
For example, I want to know if a certain register was deleted from the
database.

thanks.|||Esteban (ecastillo@.gmail.com) writes:
> Thanks Simon, I was trying this product, but I can't find an option
> that shows me a list of SQL transactions made in the database ...
> maybe I don't know how to use it.
> For example, I want to know if a certain register was deleted from the
> database.

In the version I have, there is a "View DDL commands" under Browse, and it
seems to have the information of the kind you are looking for. There is
also a filter function.

Note that for Log Explorer to be really useful, you need to have the
database in FULL or BULK_LOGGED recovery mode.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp