CREATE TRIGGER TR_ImpideBorradoMultiple
   ON MiTabla FOR DELETE
AS
   IF(SELECT COUNT(*) FROM Deleted) > 1
   Begin
      raiserror('Prohibido eliminar mas de un registro a la vez', 16, 1)
      rollback transaction
   End