I have a memo text type of field in a SQL 2000 database that my users really want to start seeing an audit trail on.
No way am I going to store copies of this field. Some of the records they dump in it are so big they run out of space in it already.
I could write it myself, but I imagine someone has already written some tool that could compare the data in this field against an original record so that I can just store the differences and then put them back together so that users can see all the different versions of this note.
Any ideas?