>CREATE TRIGGER [Meetings_Audit_Update] ON dbo.meetings > FOR UPDATE >AS >declare @tcAction varchar(500) >set @tcAction='Action ' > >IF update(begintime) or update(RoomID) > BEGIN > IF update(RoomID) > begin > INSERT INTO Audit_Meeting > (meetingnumber,begintime,endtime,patientID,roomid,actualRoomID, > ScheduledBy,BlockMember,LastAuditForm,LastAuditBy,deptID) > (SELECT meetingnumber,begintime,endtime,patientID,roomid,actualRoomID, > ScheduledBy,BlockMember,'Room Change',dbo.get_login_name(),DeptID from deleted) > END > ELSE > BEGIN > INSERT INTO Audit_Meeting(meetingnumber,begintime,endtime,patientID,roomid,actualRoomID, > ScheduledBy,BlockMember,LastAuditForm,LastAuditBy,deptID) > (SELECT meetingnumber,begintime,endtime,patientID,roomid,actualRoomID, > ScheduledBy,BlockMember,'Date or Time Change',dbo.get_login_name(),DeptID From deleted) > END >END >