I am wondering about the statements regarding nocount.  I agree that it should be set on (not only for performance but because of problems with MS data access technologies throughout their history), but a quick check of the statistics in Query Analyzer report back a single round trip for a stored proc doing a number of updates regardless of the nocount setting (though a bunch more traffic + packets received for the stored proc executed when nocount is off)..