Thanks John,

Yes, I've read a few articles of Frans Bouma before on the topic. There are good pro and cons to find in those discussions though one that is overvalued: Performance.... In most cases there is a non-measurable performance difference between the two, but it is stunning to see that argument popping up again and again. One thing that I also miss is that you can send a whole SQL script as dynamic SQL to the SQL server having many of the percieved advantages of SPs (I use this approach for processing HL7 messages). But again both dynamic and SPs have their place. The developper has to know when to use one or the other. Again trying to find a one fits all is foolish. Much depends on the type of application, its usage, security requirements, available knowledge etc.

Walter,

>Walter, check out http://weblogs.asp.net/fbouma/archive/2006/05/26/Yay_2100_-A-new-Stored-Proc-vs.-Dyn.-Sql-battle_2100_.aspx
>
>and
>
>http://discuss.joelonsoftware.com/default.asp?design.4.433180.44
>
>I think anybody who has seen any of this realizes that "SP is best" or even "SP is a good place to start" is shaky - "premature optimization" is how I think it was described in one of the online articles I read a year or two ago. Now that MS is about to push in-memory processing in its various Linq permutations, I think people will swing into line and maybe even assert that they are prophets who said it all along. ;-)