THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sqlserver » Transactions   (RSS)
Sorry, but there are no more tags available to filter with.
  • Is it time for SQL Server to have Isolated Transactions?

    SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’ serving to increase (and decrease) the @@TRANCOUNT indicator. The transaction can be committed or rolled back at any point that the @@TRANCOUNT value is equal to one. Error conditions may or may not cause the transaction ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on March 9, 2009
Privacy Statement