>If on the other hand, you doing thing things as efficiently as possible, using stored procedures, then ADO/OLE DB is a much faster and a much more efficient way of working with remote data - especially update operations.

Hi John,

PMFJI, I haven't done any work with a true back-end db server and had a question.

If you use stored procedures to do the heavy lifting don't you get stuck with only being able to scale up, ie. throw more RAM and CPU power at the db server.

If you want to scale out, add more application servers to handle the load, wouldn't using sp's make that impossible? I would think you would want all the heavy lifting in DCOM objects on application servers handling that.