Click to See Complete Forum and Search --> : Logging User Activity in MSSQL


erickwidya
June 22nd, 2005, 05:42 AM
currently i'm using TRIGGER for INSERT, DELETE, UPDATE which Insert new record to tblLogs
the table structure = UserName | DateTime | ActionTaken (I, D, U) | TableName

everything works fine until i realize that i missed important thing which is the "ColumnName" that user changed coz in here User seem easily forgotten what they have done, that's why i planning using the tblLogs

so the question would be How (if not involved complicated method)? or any other better method?

i open for any idea

thanks