I have a fundamental question regarding transactions. The two types of transactions that I am talking about are:<BR><BR>1) transaction code inside of SQL Server stored procs<BR>2) MTS transactions<BR><BR>Should we be using database transactions inside of our SQL Server code in addition to MTS transactions? Or should we be only using one or the other exclusively?<BR><BR>In other words, how are SQL Server transactions related to MTS transactions? <BR>