>I would use ReadUncommitted Transaction Isolation Level and don't use Transactions in your code at all (you don't need them for selects).
>
>I recommend these blog posts by Dmitri Korotkevich (new SQL Server MVP):
>http://aboutsqlserver.com/2011/09/28/locking-in-microsoft-sql-server-table-of-content/
>
>They explain all these things in relatively simple terms.Thanks Naomi, I'll read his blog. BTW, I'm not using any additional Transactions in code, just the TransactionScope.
I also wondered about the Distributed Transaction question I asked:
>>Complicating all this is the fact that most of our other Transactions to our own databases get elevated to Distributed Transactions at some point. I'm pretty sure that this would NOT apply to the above Transaction to our customer's database, since I've made it RequiresNew, but I don't know for sure as it would be called in the middle of a distributed transaction.Any comments about that?
~~Bonnie