Jon,
>If one is using SP's for all data access, does that essentially mean you could have at least 3 procs for each table (e.g. insert/update/delete)? Yep. It's really no big deal though. It would actually be select/update/delete though ... an insert can be handled by the update SP (if you pass it a non-zero, non-null PK, it does an update, otherwise it does an insert). We have a little VFP utility prg that automatically generates the three SP's to copy/paste to Query Analyzer or wherever.
Now, keep in mind that this is a .NET application I'm writing, but I'd do it the same way for a VFP app too. Have you read "Client/Server Apps with VFP and SQL Server" by Gary DeWitt, Chuck Urwiler, Mike Levy & Leslie Koorhan? If not, you should.
~~Bonnie