Database Log History

Like (0) Share

Report

Posted on 17 Jun 2015 12:18:45 by Jane Zielinski

We have several tables selected for Insert, Delete, Update and Rename Key. For example, I can see edits to vendors. However, when I open the History tab for a specific log entry I can't see the actual changes made. Is there some setting that is needed to record the Value and Previous Value entries for the change?

*This post is locked for comments

All responses (4)

Answers (0)

André Arnaud de Cal... 293,440 Super User 2025 Season 1 on 17 Jun 2015 at 13:13:13

Like (0)

Report

RE: Database Log History

Hi Jane,

Usually there should be no change log if you modify data in related tables. It would be interesting to find out what causes these "empty" update logs.

Can you track the users who created the changes and ask what actions they have done?
Suggested answer

Bashir Ahmad 5,248 on 17 Jun 2015 at 13:09:44

Like (0)

Report

RE: Database Log History

i think this is what you are looking for:

technet.microsoft.com/.../dd362089.aspx

Hope it will help
Jane Zielinski on 17 Jun 2015 at 12:44:01

Like (0)

Report

RE: Database Log History

I understand the relationship of the DirParty tables. If I change Terms of Payment I get the history details. But, I'm getting a lot of Update records with no details. If some linked table changes, like Approved Items or Pricing, do I get a log entry on the vendor too?
André Arnaud de Cal... 293,440 Super User 2025 Season 1 on 17 Jun 2015 at 12:31:26

Like (0)

Report

RE: Database Log History

Hi Jane,

Please explain what fields were changed. Some fields from the vendor form like the name and address are not on the vendor table itself, but are stored in other tables.