1. Every techique has its strengths and weaknesses. 2. If you really want to sell your applications to more than one party then using stored procedures gives tremendous advantages as follows: a) It separates your user interface and source code from data management. You do not need to touch your source code thereby trying to eliminate the need to have multiple versions of the source code. b) if say, you want to provide Oracle instead of SQL Server, the syntactical changes need to be made only in stored procedure, so long as the result set or result(e.g. count of records etc.) remains same. c) Many databases allow you to store procedures in an encrypted form thereby disabling accidental changes to it etc. 4. It totally eliminates the need to give rights to base tables or crucial views and forces all users to necessarily go through your consistent stores procedure path. Overall, it provides tremendous advantages as against few disadvantages. Dilip Nagle