Hi Mike,

>How does writing SPs guarantee consistency? Each SP could be written differently, accept different parameters, etc. OTOH a view uses the same mechanism every time.

Yeah, a bunch of different SP's on the same database server doing things completely differently is a possibility; if your DBA and/or IT management is/are a buncha dumbasses who aren't doing their jobs. I mean, c'mon, Mike, that's really not in the realm of reality.

I don't totally discount RVs either, but it seems to me you're being a lot more "enterprise friendly" if all queries and updates clearly identified by the biz rules are performed at the server level by SPs. This allows the DBA and/or network staff to optimize schema and hard resources.