>You haven't said anything here except reiterating the argument.

Really, read what I said. I made a distinction between business rules and action queries. I think business rules belong in the middle tier and action queries belong with the data. This gives you an additional layer of abstraction and IMO, helps to simplify application development.

>>So? I can delete all yours too. I just have to use the SPROC instead of SQL.

Oh please! The chances of someone figuring out the name of the SP and what parameters to pass, and in what order is nearly impossible. On the other hand, when you put permissons directly on a table, there is no stopping someone with an ad-hoc query program from screwing things up. Also, in big shops where the DBA and developers are not always in synch, not allowing direct access to data can prevent a developer from accidently leaving off a where clause on a delete statement and wiping the table. Yep, because RV's require direct access to data, IMO they put your data at risk.

>>No. John's valid point is that theory means little, real world numbers are the real deal.

So, where are your real world numbers? At least I'm basing my argument on the countless number of articles I've read supporting this kind of framework.

>>Uh, how about requiring a valid account for the connection? If the username >>and password are encrypted and compiled into the exe, there's your >>protection. The security argument is completely invalid, because the same >>issues apply to both techniques.

What do you do when you need to add a user, recompile the application? If you don't want users to login, then use NT authentication. SQL Server gives you that option.

>>FWIW, I am not arguing that RVs and SPT are better or worse than SPs, only >>that we haven't really been presented with convincing evidence yet, besides a >>few people spouting opinions.

I haven't seen any numbers, but a lot of experts are saying its the way to go. Even if there were no performance benefit, I would still continue to write SP driven applications. It just feels right.

Regards,
Charlie