Syed Ali discussed stored procedures and why use them. I posted my comments there but thought it was worthy of an entry in the blog. There are some things I hate about them as well but I feel they have some very distinct advantages too so they are a necessary evil. I don't see how you can argue against stored procedures. There are drawbacks just as there is with any technology but the advantages outweigh the disadvantages.