Sometimes a database may have a separate table to log certain activities taking place in the database. create a new table named ‘changelog’ in the northwind database as follows: changeid int identity(1,1) primary key empid int (will contain the id of the employee being changed) user nvarchar(30) (will contain the login of the user making the change) date smalldatetime (will contain the date of the change) oldrate money (will contain the old payrate of the employee) newrate money (will contain the new payrate of the employee) you also need to alter the employees table and add a payrate column and set a pay rate for the employees. create trigger payrate_change on employees for update as if update (payrate) after creating the changelog table, create a trigger on the employees table for update. use this trigger to monitor the payrate column, and if the payrate of an employee gets changed, have the trigger insert a row into the changelog table with the appropriate data. [use the function suser_sname() to get the user making the change and insert this into the user column.] two good resources to look at: