>What's the difference between calling a stored procedure and submitting an ad-hoc query from your point-of-view. I'm not trying to be argumentative - honest.
>
>-Mike

Mike,

A parameterized view is not an ad-hoc query. When using remote views, the basic structure never changes, only certain parameters to limit the result set. This type of view can be optimized with SQL Prepare. Ad-hoc queries, on the other hand, are queries that are written on-the-fly. For those type of queries, SQL Passthrough should be used. When should stored procedures be called? I believe they should be called when many table need to be joined or a lot of data processing needs to happen on the back end before the data is returned to the client. It's mish-mash world where experience and using the right tools for the right job requires sound judgement and a basic understanding of both you client, server and development environment. Is there is no pure and perfect solution no matter what your proclivity is.