i want to do something like that; if someone tries to update a table, the trigger will fire and add a new record that contains the field name, old value and new value.
i have already done a small part of it.
the code is below.
Code:
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[forumchange] ON test2 FOR UPDATE AS