Hiya John,
You may have already stated this and I missed it, but other strong arguments for stored procedures in SQL Server 7.0+ are:
The execution plan is compiled when the SP is created. A call to an SP need not be compiled.
SP code is re-entrant. Subsequent calls to the same executing SP run faster.
SPs allow you to hide the implementation from the interface. If the schema for the database changes, the SP can be changed without having to recode application logic.
And there are others but it's Sunday and my head is murky :-)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
