Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to know which records are updated from log analysys

Status
Not open for further replies.
jadoogar

jadoogar

Programmer
Oct 23, 2003
61
IN

Hello All,
I have a SQL database with 50 tables and a web service application running on them where about 10 tables can get data updation through web service application.

Is it possible to find out which records from which table are updated in a single day by the web interface from Log analysis.

We dont have any timestamp field in the tables, we want a solution to know which records from which tables changed on a particular day.

Please help me.
 
Status
Not open for further replies.

Similar threads

WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
632
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
607
bharons
bharons
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
802
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
613
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top