Log Changes made in database tables, not that hard as i thought

Post date: Dec 16, 2009 5:14:15 PM

create table MyTable(id int identity, namn varchar(20), primary key(id))insert mytable values ('Peter')insert mytable values ('Johanna')insert mytable values ('Ilsa')insert mytable values ('Molgan')insert mytable values ('Joe')select * from mytable create table MyTable_Log ( action varchar(20), id int, OldName varchar(20), DateChanged datetime,primary key(id))delete MyTable OUTPUT 'Deleted', Deleted.*, getdate() into MyTable_Log where id = 2update MyTable Set Namn = 'Görgen' OUTPUT 'Updated', DELETED.*, getdate() into MyTable_Log where id = 3select * from MyTable_Log