Check out this mess.   I would like to see any one of the many people commenting to show one scrap of evidence to support their side of this issue.   All I see is "I read in an article that this was bad", "M$ said this is true", and my favorite argument "because that's what I think".   Great arguments for the third grade audience.   People... please try to prove something here with some real evidence.

I happen to believe stored procedures are the way to go because Elvis landed in a spaceship in my front yard and told me to only use stored procedures.

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx