I have a SQL Server 2005 table called Backup with the following fields:
OldValue nvarchar(MAX) (contains xml)
NewValue nvarchar(MAX) (contains xml)
This table is filled by my application when a change to data in another table is made. What I do is store the old values of the table being changed and the new values and store them in my Backup table above.
I'm trying to come up with an aspx page that could visible show the details in this backup table to the users. Basically i want them to see the created date, Table Name, OldValues,NewValues.
I was thinking of having a tree view maybe by createdDate..