 <p>A few canned answers from well known experts: Paul Nielsen <a href="http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx" rel="nofollow">Why use Stored Procedures? </a></p> <p>Adam Machanic: <a href="http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/no-stored-procedures-are-not-bad.aspx" rel="nofollow">No, stored procedures are NOT bad </a></p>