Can you post the error that you are getting? Also the code in the Trigger so I can have a look at it?

In theory you can write something like this:

DECLARE @s-2 varchar(2000);

SET @s-2 = 'INSERT INTO timestmp(tablename,fieldname,recordid,timestamp,oldvalue)'

SET @s-2 = @s-2 + 'SELECT '''+ @tbname + ''','''+@fieldname+''', , now(), ' + @fieldname + ' FROM ' + @tbname

SET @s-2 = @s-2 + 'WHERE = ' + @Identity

EXECUTE @s-2;

Ok, i have excluded the cursor too loop through each field etc. If you wish to get the old value just make sure you sue the BEFORE instead of AFTER statement.

If you are still having issues, please post code and error for me 🙂