The biggest reason to use stored procedures to me is that db developers tend to stick around around a business lot longer than web developers, so putting most o

The biggest reason to use stored procedures to me is that db developers tend to stick around around a business lot longer than web developers, so putting most of the business logic into the db is better for the business in the long run. Like the many developers, I generally develop custom apps specifically for a particular business. When I develop new apps I start by by putting all the intelligence in the serer-side code, so it's easier to change things without needing to go through someone else. Once the apps stable then much of the business intelligence gets moved into stored procedures in the db level.