My question revolves around performance and maitanabilty in a data driven ASP site. (I'm using SQLServer2000) I'm curious on peoples ideas on using dynamic sql in a set of "generalized" stored procedure versus defining and creating many small stored procedures for a number of specific events. Does anybody have any guidelines, ideas on when a SQL statement becomes too complex and should be broken down into a unique stored procedure or is it better to limit the number of stored procedures and use more dynamic SQL to build my statements. Thoughts? Ideas?