I have followed the suggestions posted on this and created a trigger to set the datetime stamp in my table when
the record is added or modified. However, the datetime stamp is applied to all of the records in the table and not
just the record that has been modified.
What am I doing wrong? Could someone please help?
here is the trigger code.
CREATE TRIGGER [dbo].[updateTimeStamp] ON [dbo].[tblArchivedRecords]
SET NOCOUNT ON;
UPDATE tblArchivedRecords SET [TimeStamp] = GETDATE()