question

jleland avatar image
jleland asked

Best practice for keeping track of data changes

![alt text][1] [1]: /storage/temp/3614-storing-changes.png So when a user makes a change in table 1 a (trigger (Whats best practiced to do this?) ) that sends that data to a second table to be stored with the previous data, new data, time stamp, and the user
sql serversql server 2014best-practicebest practicesbest practice
storing-changes.png (7.9 KiB)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
How are they making the change? Stored Procedure? Manually? Via an application front end?
0 Likes 0 ·
jleland avatar image jleland commented ·
Application front end
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.