Transaction log viewing--missing data

[preisdent]

I would like to view the Server transaction log to trace how am I have been loosing data from database.

I am ussing the sqlserver 7 on nt. I have checked my code and there is nowhere th the code am deleting the data from 4 tables that are missing the data. The tables are not totally wiped out but it only happens for a particular set of data with the same code.

Thanks for the help!

 

[tlbroadbent]

There is no way to view the Transaction Log with SQL server tools. You can buy third party tools such as Platinum Technology's Log Analyzer (

http://www.platinum.com/)

or Lumigent's Log Explorer (

http://www.lumigent.com/).

I've not tried either product and am not endorsing - only mentioning them. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes