Log_Explorer by Lumigent Technologies is the best tool to explore transaction logs. You can download its free demo form www.lumigent.com. Aman DBA Chenab Ltd.
Log Explorer trial edition will work only on Northwind, pubs and there own database. As far as I know It won't work with other databases. Is there any way of checking it for our database? G.R. Preethiviraj Kulasingham
No you must purchase license, spend $$ to get peace of mind. For free you can use DBCC LOG to read, but it may not be understandable easily, check this link http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp] for more information. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Here is a 14 days evaluation key by which you can explore your own DBs. "xxxxx" [Deleted by Moderator] It will work with Ver 3.00. Aman DBA Chenab Ltd.
Aman, make sure you comply with T&C by Lumigent. I appreciate your help but never ever reveal product keys or licence keys in a newsgroup, its for your safety too. _________ Satya SKJ Moderator SQL-Server-Performance.Com
quote:Originally posted by barozai Log_Explorer by Lumigent Technologies is the best tool to explore transaction logs. You can download its free demo form www.lumigent.com. Aman DBA Chenab Ltd. please check out LockwoodTech Log Navigator athttp://www.lockwoodtech.com/index_lognavigator.htm Brian Lockwood LockwoodTech Software http://www.lockwoodtech.com
I guess Microsoft must provide some API or functions to Lumigent to access the sql server log.and I think maybe we can write a applcation to read the log with any tools/program language that such as C,VB,Java,Delphi... I hope we can discuss that how to do it. Jelly.
You could get more information from Brian with regard to log navigator application which is under testing on other forum, check it out or contact Brian Lockwood at ApexSQL. _________ Satya SKJ Moderator SQL-Server-Performance.Com
You can use something like DBCC LOG (<your_db>,-1) However, when you are not used to do your every day life in hexadecimal, I would spent this money for a third-party tool. I haven't tried yet, but did you have a look athttp://www.sourceforge.net ? I know there are plenty of open SQL Server projects around there. Maybe even one for this purpose. Frank http://www.insidesql.de http://www.familienzirkus.de
Frank Do you agree the output from DBCC LOG is anyway readable/understandable, unless you're expert in hexadecimal computations its no easy task. Longback, I left my wish (read Tlog without using third-party tools) to MS to add this facility atleast in YUKON, wait and see. _________ Satya SKJ Moderator SQL-Server-Performance.Com
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Do you agree the output from DBCC LOG is anyway readable/understandable, unless you're expert in hexadecimal computations its no easy task.<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />I definitely do agree !!!!<br /><br />I know one thing or two about hexadecimal, but there are more interesting things in life to cope with. That's what I wanted to point out. Hope nobody got me wrong. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />So in clear words:<br />Save time, money and mental health and use a third party tool. Stay away from doing this on your own.<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
I had a look at ApexSQL,There is a good tool to view SQL Server Log.But it has no any information that about how to access SQL Server Log. as Staya said,DBCC LOG isn't easy task.I want to know how to read the new/old record when I update a record?Lumigent Log Explorer can do this but how to do with other Language??Any suggeustion? Jelly.
Well if interested can talk directly to Brian for more understanding about his product or lastly may take help from MS Support which is unlikely will workout. _________ Satya SKJ Moderator SQL-Server-Performance.Com
