RE: SqlTransaction, t-sql transactions, and distributed transactio

Hi Mark,

I'm suggesting to use either SqlTransaction or BEGIN TRAN here, is because
this will make your code more clear. Also, duplicated transactions will
result in a performance hit. If your engineers will use SqlTransactions in
their .NET code, I just suggest you not use transaction in your stored
procedure, unless your program requires.

Does that answer your question? Please let me know if you have questions.

Kevin Yu
Microsoft Online Community Support
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

.