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
2 comments
10 |1200 characters needed characters left characters exceeded

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

How are they making the change? Stored Procedure? Manually? Via an application front end?
0 Likes 0 ·
Application front end
0 Likes 0 ·

0 Answers

· Write an Answer

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.