I have occasionally modified a sproc, only to find that a conflicting check-in has also modified that same sproc. One of our modifications has been overwritten by the other.
I do concede it is rare, but it happened, and we only discovered the bug too late.
However, the second scenario would happen every single day in a team.