I am playing around with SVN trying to get a better feel for how it works. I added some files to my repository and checked them out into 2 separate working directories. For working directory 1 I am using my SQL client software (Aqua Data Studio) to modify the file and working directory 2 I am just using Windows Explorer with TortoiseSVN.
My question is, does SVN or the clients built on top of it, never show when a file in your working copy is out of date? If I make a change in working directory 1 and commit I would expect to see working directory 2 notify me that my working copy is out of date with the repository. Is this ever the case? Is there any way to tell which files in my working directories are out of date or do I just need to be careful to always update prior to making a change to a file?