HI, I'm using sql server 2008 express and VB.net 2010
I have a database that records an employees personal details.
But I have to develop some way for recording changes to the record. ie what was changes and who changed it and when.
It may get changed multiple times so does sql server have anything built in to do this or do I do it all programmatically?
So do I create a history table which would add a considerable overhead/complexity to an otherwise simple system?
Do I record every change seperately or record the whole record each time?
Any suggestions/ guidance appreciated...