SQL Server 2005 Transaction/ Log file

• Steven Roberts-371775

  SSC Enthusiast

  Points: 127

  More actions

  February 10, 2009 at 4:47 am

  #383903

  Hi Guys,

  It is possible to investigate the transaction logs to idenftify when changes were made to data in a particlaur table. If so, where can i find it i.e. what is the default path?

  Note, this table is effectivley a dimensional table which does not update/ change very frequently at all.

  Thanks for you help.

  Steve

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  February 10, 2009 at 5:16 am

  #941100

  It is possible to look at the log, but you will need to buy some software to enable you to do this as the log is very complex and cannot be easily understood..