I'd also like to hear a reasonable answer to that question. For me, the only advantages of stored Procs over straight SQL (generate or hand coded) are: * Secu

I'd also like to hear a reasonable answer to that question. For me, the only advantages of stored Procs over straight SQL (generate or hand coded) are: * Security - you can revoke rights to directly access / change the tables from the app layer, making all access be through procs. However, in general you can probably create a similar security setup using views. * Many SQL calls that need to be run as a set to give a single answer - this avoids the round trip latency of firing many SQL calls from the application. I'd am genuinely interested to hear of more advantages.