Not to mention, Chris, that if you make most of your queries server-side, you can beef up performance by upgrading ONE machine, and not every client machine. to me, that's the great attraction.

>Yes, generally it is better to use stored procedures on the server (SQL Server 7 in my case). Your stored procedure (sproc) can do a number of things, including returning a set of records (result set).