>
You say "should be manifested". Why? I'm not busting balls here, I just want to learn.
>

The granularity of control you get with SP's is not matched by anything else. Look at my 5 point response to Bob Archer on more points..


>
Here, I'm am refering to n-phase commit code for a transaction envoked in an SP.
>

MTS has a 2-phase commit system as well. MTS transactions are more concerned with Tx's among components.. There is no reason why MTS Tx's and SQL Server Tx's cannot live in harmony... You need to explain your concerns a bit more here...


>
I'm learning. Guess I shouldn't make a conclusion until I have fully experienced the alternatives.
>

That is a very good idea...