TR_CLIENTUSERSCIPHERSALT_UPDATE

          create trigger [dbo].[TR_CLIENTUSERSCIPHERSALT_UPDATE] on [dbo].[CLIENTUSERSSALTCIPHER] after update not for replication
            as
            begin
                if (update(SALTEDKEY)) begin
                    insert into [CLIENTUSERSSALTCIPHERHISTORY] 
                    (
                        [CLIENTUSERSID]
                        ,[SALTEDKEY]
                        ,[CIPHERHISTORYID]
                        ,[ADDEDBYID]
                        ,[CHANGEDBYID]
                    ) 
                    (
                        select 
                            INSERTED.CLIENTUSERSID
                            , INSERTED.SALTEDKEY
                            , CUCH.ID
                            , INSERTED.ADDEDBYID
                            , INSERTED.CHANGEDBYID                 
                            from INSERTED
                            inner join CLIENTUSERSCIPHER    as CUS    on INSERTED.CLIENTUSERSID    = CUS.CLIENTUSERSID
                            inner join CLIENTUSERSCIPHERHISTORY as CUCH on CUCH.CLIENTUSERSID        = INSERTED.CLIENTUSERSID 
                            and CUCH.CIPHER = CUS.CIPHER
                    )
                end
          end