TR_CLIENTUSERSCIPHERHISTORY_INSERT

          CREATE trigger [dbo].[TR_CLIENTUSERSCIPHERHISTORY_INSERT] on [dbo].[CLIENTUSERSCIPHERHISTORY] after insert not for replication
          as
              begin
              set nocount on;
                  declare @CLIENTUSERSID int;

                  select @CLIENTUSERSID = INSERTED.CLIENTUSERSID from INSERTED;

                  delete from CLIENTUSERSSALTCIPHERHISTORY 
                  where CLIENTUSERSID = @CLIENTUSERSID 
                  and CIPHERHISTORYID not in (
                                                  select top 6 ID 
                                                  from        CLIENTUSERSCIPHERHISTORY 
                                                  where        CLIENTUSERSID=@CLIENTUSERSID 
                                                  order by    DATEUSED desc
                                              ) 

                  delete from CLIENTUSERSCIPHERHISTORY 
                  where    CLIENTUSERSID = @CLIENTUSERSID 
                  and        ID not in (
                                          select top 6 ID 
                                          from    CLIENTUSERSCIPHERHISTORY 
                                          where    CLIENTUSERSID=@CLIENTUSERSID 
                                          order by DATEUSED desc
                                      );
            end