Hi, I neeed to add a column on a few table which would show me the date and time a new record was inserted or a record was updated on the table.I created a column called LastModified with a datatype timestamp but it showing me binary values.Can I know why and if there is another of doing it then please let me know?
Timestamp is not useful for audit log, it is just use to version-stamp rows. Better add a datetieme column along with GetDate() as default attached to it and add an Update trigger which will update this datetime column (LastModified) with current date.
field to show inserting and updating of records
Forum Locked
Posted - 09/01/2006 : 10:24:42
