TR_TIMEOUTINACTIVITYSETTINGHISTORY

                CREATE TRIGGER [dbo].[TR_TIMEOUTINACTIVITYSETTINGHISTORY] ON [dbo].[Setting] AFTER INSERT, UPDATE NOT FOR REPLICATION
                AS
                BEGIN
                    SET NOCOUNT ON;
                    IF EXISTS (SELECT 1 FROM inserted i WHERE i.Id = 194)
                        BEGIN
                                INSERT INTO TIMEOUTINACTIVITYSETTINGHISTORY (SETTINGID, SETTINGVALUE, CHANGEDBYCMSUSERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                                SELECT i.Id, i.[VALUE], ISNULL(i.CHANGEDBYCMSUSERID, 0), i.CHANGEDBYID, i.CHANGEDBYID, i.UpdateDate, i.UpdateDate 
                                FROM inserted i  inner join dbo.SETTING s on s.ID = i.ID
                                WHERE i.Id = 194
                        END 
                END;