How to view transaction logs in SQL Server 2008 [closed]

by

You could use the undocumented

DBCC LOG(databasename, typeofoutput)

where typeofoutput:

0: Return only the minimum of information for each operation -- the operation, its context and the transaction ID. (Default)
1: As 0, but also retrieve any flags and the log record length.
2: As 1, but also retrieve the object name, index name, page ID and slot ID.
3: Full informational dump of each operation.
4: As 3 but includes a hex dump of the current transaction log row.

For example, DBCC LOG(database, 1)

You could also try fn_dblog.

For rolling back a transaction using the transaction log I would take a look at Stack Overflow post Rollback transaction using transaction log.

More Related Contents:

  1. How do you clear the SQL Server transaction log?
  2. Where clause not working in sql server
  3. Alias name is same as column name [closed]
  4. T-SQL stored procedure that accepts multiple Id values
  5. LocalDB deployment on client PC
  6. Understanding PIVOT function in T-SQL
  7. The order of a SQL Select statement without Order By clause
  8. How do I escape a percentage sign in T-SQL?
  9. Using RegEx in SQL Server
  10. What is the best way to auto-generate INSERT statements for a SQL Server table?
  11. SQL Server named instance with Visual Studio 2017 Installer project
  12. Get list of databases from SQL Server
  13. CAST and IsNumeric
  14. SqlServer: Login failed for user
  15. Hidden Features of SQL Server
  16. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  17. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  18. EXEC sp_executesql with multiple parameters
  19. SQL Server – Dynamic PIVOT Table – SQL Injection
  20. Best data store for billions of rows
  21. newid() inside sql server function
  22. How can I use a single mssql connection pool across several routes in an Express 4 web application?
  23. When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
  24. SSIS reading LF as terminator when its set as CRLF
  25. What are some ways of accessing Microsoft SQL Server from Linux?
  26. LPAD in SQL Server 2008
  27. Why is casting from float to varchar being rounded in SQL Server?
  28. In SQL Server, how can I find everywhere a column is referenced?
  29. SQL Server stored procedure return code oddity
  30. Convert float into varchar in SQL Server without scientific notation

Leave a Comment