>>Futhermore, it is now common knowlege that most business rules should not reside in SPs. Too many round trips to the server, not to mention servers getting bogged down with processes that could be executed on another tier. Again, .Netters have to rely more on SPs because there are no alternatives at this time. I say "at this time" because Microsoft is finally doing something about it.
>
>I don't know where it comes from that .netters HAVE to use SP's and only SP's, to access the db. They CAN, just like VFP also can use them ... if appropriate ...


Pscal, we also have huge data requirements and complex reporting requirements for our clients filings with the SEC; we have millions of records that are being distilled and complex logic also, but egads, stored procs, .Net and ADO handle the capacity just fine. Guess we'll have to give it all up and reinvestigate using VFP for our data.... lol...