Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TransactionScope and SQL Server Locks
Message
 
 
To
19/04/2012 12:30:07
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01540816
Message ID:
01543743
Views:
54
>>I ran across this post this morning:
>>
>>http://blogs.msdn.com/b/dbrowne/archive/2010/06/03/using-new-transactionscope-considered-harmful.aspx

>
>Thanks Paul ... I knew about the default Serializable and how to easily get around that (see my blog post from more than a year ago, http://geek-goddess-bonnie.blogspot.com/2010/12/transactionscope-and-sqlserver.html), but I did NOT know about the default Transaction Timeout of 1 minute.
>
>I think that's probably ok in our scenario (a 1 minute timeout), but now that I know about it, I can review our processes and evaluate whether or not that's ok. Thanks!
>
>~~Bonnie

Take a look also at this thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/bf1bca4d-750c-45a8-a149-95c39f6ec2f3 I think it may be helpful.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform