Okay, I have a trigger on my people table that looks like this:

CREATE TRIGGER insertTransactionTurned18

ON dbo.people

FOR UPDATE

AS

DECLARE @personid int,@oldage int,@newage int

SELECT @oldage = age

FROM deleted WHERE active=1

SELECT @newage = age,@personid...

Hey guys - thanks for the responses!

What I'm trying to do is keep a table with human-readable history for each person in my people table. Whenever significant events happen on...