TR_CLIENTUSERMAILFORWARDING_DELETE

        create trigger dbo.TR_CLIENTUSERMAILFORWARDING_DELETE on dbo.ClientUserMailForwarding 
        after delete 
        not for replication
        as begin

            set nocount on;
          declare @CLIENTUSERID int;    

            if (select count(ID) from DELETED) = 1
            begin
              select
                @CLIENTUSERID = DELETED.CLIENTUSERSID
              from 
                DELETED;

               if @CLIENTUSERID is not null
               begin
                    declare @NETCOMMUNITYCLIENTUSERID uniqueidentifier;

                    select
                        @NETCOMMUNITYCLIENTUSERID = NETCOMMUNITYCLIENTUSER.ID
                    from
                        dbo.NETCOMMUNITYCLIENTUSER
                    where
                        BBNCUSERID = @CLIENTUSERID;

                    if @NETCOMMUNITYCLIENTUSERID is not null
                    --Delete the email forwarding address integration record associated with the netcommunity user
                    delete dbo.NETCOMMUNITYEMAILINFO where NETCOMMUNITYCLIENTUSERID = @NETCOMMUNITYCLIENTUSERID;
               end
            end
        end