When designed properly, sql injection protection.

So you'll assemble parameterized SQL at the client, then pass it to a SP to run? This is one of the reasons why SP is better?

He didn't say every. He said most. I love your arguments based on absolutes.

Direct quote:

Each time I've received feedback and follow-up emails from attendees (some of whom were VFP people) that agreed that stored procs are always the best way to go. Always? Agreed? With whom?

I do listen to other peoples experience, but do not take anything for granted from ANYONE. Whether you are named "Chris Date", "Joe Pescoe" or "Kevin Goff", you'll have to give me the absolute evidence and prove that your assesment makes sence in every circumstance.

If you want an assessment that makes sense in every circumstance, it seems you are limited to death and taxes. ;-)

You have a heart condition and you have two alternatives... In your world, you'd go to the pill hack. In mine, to the surgeon..

A doctor who offers an unproven treatment is either running an approved scientific trial and has patient consent, or is a quack. This contrasts with IT where vendors can make all sorts of untested claims and practitioners willingly apply it to customers, while calling everybody else a quack!