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 |
|
deakins
Starting Member
2 Posts |
 Posted - 2005-09-30 : 02:48:41
|
| Hi,My problem is that I haven't inserted a field in tables i.e last update date field. I want to get the the last update date of insert, update and delete queries. The problem is that I have to extract it from the existing system i.e i cannot make any changes to database. The only thing that comes to my mind are the ldf log files but those files are not readable. How can I convert those files in simple text format so that i cah access them easily and scan the file for recent inserts, updates and deletes.Regards,Deakins. |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-09-30 : 03:08:11
|
| You could buy a program such as Lumigent Log explorer that can read the logs and export them as SQL, XML, HTML or CSVsteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-30 : 07:18:19
|
| Restore yesterday backup (i.e. on a daily basis) to another database and compare the two for differences - and log them to somewhere else?That would only give you granularity of "changed within this day".If you have Transaction log Backups you could restore those, comparing after each restore, then you would know to within the period of each transaction log backup - so if you make TLog backups every 10 minutes then you would know the change-date to within 10 minutes.Kristen |
|
|
|
|
|
|
converting .ldf files to .txt