Transaction Log Quering

• engin hazar

  Newbie

  Points: 1

  More actions

  February 6, 2004 at 12:34 am

  #108860

  Hi

  How can I transaction Log Quering

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 6, 2004 at 12:54 am

  #493002

  Best bet is to use a third party app like Lumigent Log Explorer.

  If you want to do this on your own, you can use the undocumented DBCC LOG('your_db_name',-1) command.

  Please post next time in the appropriate forum. This is for questions concerning 'Question of the day'.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]