Hi , Im using sql server 2008R2.
I am looking for a way to setup a database such that if a user changes any of the data in a table, the previous value is stored in a history file, the name of the user and date and time of change.
But I'm conscious this could cause a major overhead for the database continually recording previous values for every piece of record changed.
So I would like to ask, has anyone done something similar and how they got on and is it worth the effort?
What pitfalls to look out for and just general guidance on the best way to do it?
Thanking you....
I am looking for a way to setup a database such that if a user changes any of the data in a table, the previous value is stored in a history file, the name of the user and date and time of change.
But I'm conscious this could cause a major overhead for the database continually recording previous values for every piece of record changed.
So I would like to ask, has anyone done something similar and how they got on and is it worth the effort?
What pitfalls to look out for and just general guidance on the best way to do it?
Thanking you....