Mike,
While I agree with you in terms of performance, isn't it true that extensive (or exclusive) use of stored procedures conflicts with the notion of separating business logic from the data.
I'm not making a value judgement here. In fact, I'm reevaluating my own thinking on issues concerned with business logic/rules, etc. and would like to hear your opinion.
>My personal opinion, is to use SPT and call stored procedures. You'll be required to know the different variations of queries but overall you'll get the best performance.
- Jeff