Database Log History

(0) Share

Report

Posted on 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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

André Arnaud de Cal... 306,376 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jane Zielinski on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like
a
(0)

Report
Copy link

Link copied!

i think this is what you are looking for:

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

Hope it will help

Was this reply helpful? Yes No
André Arnaud de Cal... 306,376 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No