>>I use a lot of SPs and so do a lot of other people that hit the data I find I need to have the backend handle a lot - especially defaults
Yes, if several people share SP's then the defaults make sense.
My first .NET apps used SP's almost exclusively as I did with VFP but I've moved toward doing more in the middle tier because I have to be there anyway and the datasets are so slick to work with.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.