Original link: Why I Hate Stored Procedures / Benjamin Day.
I cannot give the arguments for stored procedures as I do not like stored procedures myself!! :-)
I would only use them if it saves a significant number of app-db roundtrips.