Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 track down problem through tran log?

Author  Topic 

qwertyjjj
Posting Yak Master

131 Posts

Posted - 2007-12-20 : 08:33:09
I need to track down a problem that happened on the server yesterday.
It might be a alter table or a lock on a table.
I can view the transaction log but it doesn't say the exact sql statements or time something happened.
ANy ideas how to lokk at this?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2007-12-20 : 12:44:42
3 third-party tools that let you see the log files in a somewhat readable format:

http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
http://www.lumigent.com/Products/le_sql.html
http://www.apexsql.com/sql_tools_log.asp

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -