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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-04 : 08:05:50
|
| kehul writes "How can i view transaction log in mssql server 2000." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-04 : 08:30:12
|
| NO you cannot view transaction log entries.--------------------------------------------------------------Edited by - Nazim on 04/04/2002 08:31:35 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 09:14:06
|
| Unless you use Log Explorer from Lumigent:http://www.lumigent.comThey have an evaluation version, so you can try it before you but it.You can also use the DBCC LOG command (it's undocumented), like this:DBCC LOG ('pubs')Just replace pubs with the name of your database. Unfortunately the output from this is cryptic, you won't see actual data values and such. Log Explorer is more likely what you're looking for. |
|
|
|
|
|
|
Transaction Log