I had the good fortune to have a discussion with an associate a few weeks back who was touting the great benefits of stored proecedures... yata yata....

I remember arguing this debate a couple years back. I found a good blog that actually discusses why stored procedures are bad. For the record... I think stored procedures have their place but not to the exemption of dynamic SQL or even coded SQL in certain cases. Anyway heres the blog:

FOR

AGAINST