>Do you still use SP to get data back into the database? How about nulls via SP? How about change management- e.g. what happens if the front desk clerk and the lawyer simultaneously update 2 different fields on the current client's record?
>

Maybe we should email "RVBoy" and ask him :)

On your last question, that can (and has) been addressed before, it's really independent of whether someone is using sprocs or not.