Is there a utility to read the transaction logs for SQL Server 2000? What
about SQL Server 2005? I need to review the transaction logs for two of my
databases to see if/when some table columns were altered from 'null' to 'not
null'. Please let me know. Thank you.
--
Thank you for sharing your knowledge

Ellen,

Check out:
http://sqlserver2000.databases.aspfa...log-files.html

RLF

"Ellen" <DBAEllen (AT) community (DOT) nospam> wrote

Thanks , I will check them out. Any preference? Looks like Apex has a free
trial.

--
Thank you for sharing your knowledge


"Russell Fields" wrote:

I don't have a direct recommendation of one over the other since it depends.
Note that Red Gate's SQL Rescue is now free (but unsupported) for SQL Server
2000, but does not exist for SQL Server 2005.

RLF


"Ellen" <DBAEllen (AT) community (DOT) nospam> wrote

Hi Ellen,
To let us better understand your concern, could you please let us know why
you would like to read the transaction log files?
Currently Microsoft does not publish an official tool or method to read
transaction logs. Some third-party vendors who have licensed the file
layouts from Microsft are able to develop a tool to read transaction logs.
From my search, there are some compatible tools with SQL 2000 now, such as
Log Explorer, however there seems no tools for reading SQL Server 2005
transaction log files.

Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Charles,
I wanted to see which columns and when, some columns on a few tables had
been changed from 'null' to 'not null'. Looking through the log was one way
to find that out relatively quickly and easily if there was a tool to read it.
Oracle and Informix both have log explorer tools that I have used to good
advantage in the past.
Thank you for your interest.

--
Thank you for sharing your knowledge


"Charles Wang[MSFT]" wrote:

Since MS has licensed the log layouts to 3rd vendors so that they can produce
very useful tools, why don't MS publishes the layouts so that some smart
people can develop better tools for free?

Oracle provides the log explorer for free, which is quite valuable.
--
npoto


"Charles Wang[MSFT]" wrote:

I am not sure if there is any marketing strategy, but I think that this is
a good idea.
Could you please give Microsoft feedback via
https://connect.microsoft.com/sql so that you suggestions will be routed to
the product team and this feature may be included in the next release of
SQL Server?

Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi Ellen,
Thanks for your response and let me know your real concern.

I will try to consult the product team to see if there is a possible
way/plan for SQL Server 2005/2008 to do this now. If there is any response,
I will get back to you and post it here.
Now I recommend that you could submit a feedback to Microsoft via
https://connect.microsoft.com/sql. This is a good channel for Microsoft to
hear customers wishes and suggestions.

If you have any other questions or concerns, please feel free to let me
know.

Best regards,
Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi Ellen

SQL Server ships ::fn_dblog() which is a system function that outputs
entries currently in the tlog.

I've blogged a sample on how to use it a few years back (not much has
chaanged) here:
http://blogs.sqlserver.org.au/blogs/.../11/26/37.aspx

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com

"Ellen" <DBAEllen (AT) community (DOT) nospam> wrote