TR_SYSTEMROLEAPPUSERSITE_DELETED

                    CREATE trigger dbo.TR_SYSTEMROLEAPPUSERSITE_DELETED on dbo.SYSTEMROLEAPPUSERSITE after delete not for replication
                    as
                    begin
                        delete from dbo.SITEPERMISSION from DELETED where DELETED.SYSTEMROLEAPPUSERID = SITEPERMISSION.SYSTEMROLEAPPUSERID    
                        exec dbo.USP_SITEPERMISSION_UPDATEPERMISSIONS
                    end