Every once in a while you get the discussion wheter or not to use stored procedures. Working with a fully dynamic (own written) ORM Its not an issue to me unless I really need that last vew percentage of performance (note! in SQL2005 this is only a vew %, in SQL2000 it can be over 10%)

Here an article:

http://www.simple-talk.com/2005/04/11/to-sp-or-not-to-sp-in-sql-server/

Ref in this article (allready posted b4, but cant be repeated enough :-) ):
http://www.unixwiz.net/techtips/sql-injection.html