I would like to write a trigger for 5 fields in a table. If any or all of those 5 fields data changing I would like to write that data into a history table. History table looks like this:
ID, FIELDNAME, FIELDDATA, DATEMOD
fieldname is the name of one of the five fields that the data will change...and fielddata is the changed data...and DATEMOD is the date the data was changed.
One other question. Will this trigger change depending on version of SQLServer 2005 or 2000?