Mat,
>>Why do you highly recommend stored procedures for everything?<<You saw a couple of reasons in Tom's reply. Security might be another reason. If I recall correctly, I believe that you can limit access to a Database so that it can only be accessed through Stored Procs (I don't remember the specifics of this right now, and someone please correct me if I'm wrong about this). In this way you can protect the integrity of your data, since the SP's would limit how one updates data. There's probably other reasons that I'm not thinking of off the top of my head, but these sound pretty good to me so far.
~~Bonnie