We currently use Visual Studio 2008 v9.0.  When one user opens a proc on Monday (but does not check it out as they have no intention at that time to make changes) if another user checks out the proc on Tuesday , makes changes and checks it in.  There is nothing to stop the first user from making changes to the proc as he/she  has it in front of him (fro  Monday) and overwrite the changes that user 2 made on Tues.
Is there a way to prevent this - e.g. automatically refresh, or not allow changes checked in if not using the latest file or the problem seems to be that if you have a proc open, you can directly make changes and it will then get flagged as checked out, perhaps if this could be disabled so that the only way to check out a proc would be to reopen from scratch