use instead of trigger for blocking delete

ALTER TRIGGER [dbo].[ToBlockDeleting]
   ON  [dbo].[t]
   INSTEAD   OF   DELETE 
AS 
BEGIN

 
 update t set flag=flag+1 where t.id=(select  id from deleted)
 

END

GO