Evaluation of Stored Procedures for the .NET Developer
Personally, I write and use SPROCs in all of my ASP.NET/WinForms + MSDE/SQL 2000 projects extensively, and I saw lots of discussion/blogs about Dynamic SQL, SPROCs, Ad hoc SQL script... everywhere.. and now, VS Developer Center provide a pretty good (short and neat) article of SPROCs for .NET developers. Check it out: Evaluation of Stored Procedures for the .NET Developer