consideringConsidering all the above cases, I would like to add 1one more. The choice of SP may be depends on people choice as well.
I personally feel frustrated when people puts very complex logic in SP and I believe such SP is very complex to maintain and debug. Even many cases the developer himself faces problem when debugging in code behind (say language part) is much more easier than in SP.
SP should only be used for simple operations. Well that is my choice.
- Rimbik