>Fair enough and I am not totally against using ad hoc queries but i do feel that using Stored procedures is a much better coding practice. To me it simplifies data access by providing a uniform interface.
>
>Using Stored procedures also makes life much easier for n-tiered apps. If you decide to move to a web interface or a new front end then alot of the work is already done.
>
>Just my 2c
Well SPs have a number of good reasons.
However your second paragraph was really what I meant with problems they cause. For n-tiered applications SPs are sort of a bottleneck. They are part of data storage layer and it only helps creating more dependency to storage layer. IOW SPs make it harder to move to a web interface or a new front end which I assume you meant an OO one.
Cetin